4 Replies Latest reply on Aug 26, 2013 12:00 PM by Frank Kulash

    selecting single record from multiple record based on date

    Thej

      Hi experts,

       

      I have a table which contains the multiple records for single ID No. Now i have to select single record which contains the latest date.

       

      here is the structure

       

      Name   Null Type        

      ------ ---- ------------

      ID_P        NUMBER      

      NAME_P      VARCHAR2(12)

      DATE_P      TIMESTAMP(6)

       

      Records

      ---------------------

      1 loosi     22-AUG-13 01.27.48.000000000 PM

      1 nammi  26-AUG-13 01.28.10.000000000 PM

      2 kk        22-AUG-13 01.28.26.000000000 PM

      2 thej      26-AUG-13 01.28.42.000000000 PM

       

      now i have to select below 2 rows how can write select qurie for this?

      1 loosi     26-AUG-13 01.27.48.000000000 PM

      2 thej      26-AUG-13 01.28.42.000000000 PM