3 Replies Latest reply: Apr 24, 2011 12:42 AM by Pooja Nanda RSS

    max(Load Date) function

      Hi all,

      Can anyone answer how can I load the latest loaded(4/20) record i.e C.

      Here among the three dates most recent date is 4/20. so I need to load the corresponding Val i.e.C using the group by function on year and No.But I am not sure what function/expression needs to be used to find out the latested load_dt.

       

      Year No. load_dt Val

      2011 1 2/20 A

      2011 1 3/20 B

      2011 1 4/20 C

       

      Thanks,Pooja