select * from (select empId,salary,RANK() over (order by salary desc) as rank from Emp ) as p where rank=5
Top
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)