4 Replies Latest reply: Feb 6, 2018 7:09 AM by omar bensalem RSS

    How to get second Highest Rank for each ID in table

    Naresh Bandari

      Hello everyone,

       

      I have Table:

       

      ID Value Rank   

      1     10       1

      1     20       2

      1     30       3

      2     25       1

      2     35       2

      2     42       3

      2     45       4

       

      Generally we know, for ID= 1 we will get second highest rank is 2 and for ID=2 second highest rank is 3.


      desired Table should be like this:


      ID Value Rank

      1     20      2

      2     42      3


      Can someone help me with this?