Somebody tell me why?


  • 0
    Z

    select t.Salary from (
    select a.*,RANK() OVER (ORDER BY Salary desc Nulls last)
    AS nbr from Employee a
    ) t where t.nbr=2

    Somebody tell me why?


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.