4 Replies Latest reply: Apr 4, 2016 8:16 AM by Sunny Talwar RSS

    How to get the first order date and amount form the table?

    gaurav gopale

      hi

       

       

      I have the following  order table

       

      Customer_id order_id order_amount order_date

      customer_idorder_idorder_amountorder_date
      1001100001/01/2016
      200234502/02/2016
      300332403/03/2016
      100434212/03/2016
      400523420/03/2016
      100656721/03/2016

      form the above table i want to make another table using resident load in which in want the following

       

      i want the customer_id and it's first order date and first order amount as follows

      customer_idfirst_order_datefirst_order_amount
      101/01/20161000
      202/02/2016345
      303/03/2016324
      420/03/2016234

       

      can anyone help me

       

       

       

      thanks in advance