7 Replies Latest reply on Dec 3, 2012 8:29 PM by Sven W.

    i want to get the second highest salary  of the  person 1

    user10941925
      Dear All ,


      I have record of one person in table PAY_ELEMENT_ENTRY_VALUES_F like , i want to get the second highest salary in of 1 person , can you help me in this regards


      SELECT MAX(Effective date) FROM PAY_ELEMENT_ENTRY_VALUES_F


      Person_id Person_Name salary Effective date

      1 hussain 6000 01-jan-2011

      1 hussain 7000 01-mar-2011

      1 hussain 8000 01-Oct-2011

      1 hussain 9000 01-DEC-2011


      Regards