1 Reply Latest reply: Jul 8, 2013 1:05 PM by Frank Kulash RSS

    How to get the 2nd lat row based on the date field

    1009700

      I have the below records in a table:

                              


      UNIT_RETAIL


      QTY


      AMOUNT


      GROSS_PROFIT_AMT


      ACTION_DATE


      3.99


      0


      0

       


      30-JAN-12


      1.99


      0


      0

       


      12-JAN-13


      1.49


      0


      0

       


      06-APR-13

       

      I have to get the unit_retail from the last action_datei.e 06-APR-13.

      My result should be 1.99 . I have to get the unit_retail from the date just before the last date.