How to find Nth highest salary in ms sql server
some guys confused how to write a query for getting output in sql server. there are so many way to get Nth salary .......... i am explaining two ways below find : select * from (select Dense_Rank() over (order by salary desc) as denserank,salary from SalaryMaster) as r where denserank= Value Value=on which position rank you want i.e. 2 or 5th this is a Dense_Rank() function which gives you a sequence without skipping a number order. this is the best way to get Nth salary in a query. -------------------------------------------------------------------- 2nd way. with CTE with CTESalary AS ( Dense_Rank() over (order by salary desc)as denserank, ,salary from SalaryMaster ) select * from CTESalary where denserank=2