3 Replies Latest reply: Oct 8, 2016 4:07 AM by gaurav gopale RSS

    how to load max date row from the table ?

    gaurav gopale

      hi all

       

      I have the following table

       

      IDDateAmount
      00101-Jan-20161000
      00102-Feb-20162000
      00101-Mar-20164000
      00201-Aug-20166000
      00201-Dec-20167000

      From the above table i have to load only those records which has max date for each ID

      the output should be as follows

      IDDateAmount
      00101-Mar-20164000
      00201-Dec-20167000

       

       

      can anyone help me in this ?

       

      Thanks in advance