3 Replies Latest reply: Feb 16, 2012 11:53 PM by jagan mohan rao appala RSS

    Load maximum date only

    Heri Zhang

      hi there!

       

      I have question to ask

      sample table like this (format date : mm/dd/yyyy):

      ID          Name          Date

      1           John            1/6/2011

      1           John            3/2/2011

      1           John            4/20/2011

      2           Andy            2/1/2011

      3           Jean            3/3/2011

      3           Jean            4/7/2011

      4           Chris            1/1/2011

       

       

      what i want is to load the table where the date is maximum date like this :

      ID          Name          Date

      1           John            4/20/2011

      2           Andy            2/1/2011

      3           Jean            4/7/2011

      4           Chris            1/1/2011

       

      how to solve it? thanks all