Ways to get N th largest salary in SQLSERVER

[deveshakgec]

Approach 1 using DENSE_RANK()


Consider following details
table: Emp
Column: name, Salary

(SELECT name , salary , DENSE_RANK() over (order by salary desc) AS Rowno FROM emp) a 
Where a.Rowno=3

Above example is for getting third largest salary.


Appraoch 2: using subquery

SELECT MIN(Salary) from EMP where salary in 
(SELECT TOP 3 salary from emp e order by salary desc)

[Rabbit]

Please use code tags when posting code or formatted data.

What is your question? You seem to have answered yourself.