2 thoughts on “How to find n’th highest salary from table in sql server”

1. Hitesh December 22, 2015 at 8:05 AM

   We can get nth highest salary using Common Table Expression (CTE).

   WITH SalaryDenseRank As
   (
   SELECT *,
   DENSE_RANK() OVER (ORDER BY Salary DESC) as Rank
   FROM tblEmployee (Nolock)
   )
   SELECT *
   FROM SalaryDenseRank
   WHERE Rank = n
2. Babulal Sah May 24, 2016 at 6:20 AM

   We can also get nth highest salary using Common Table Expression (CTE) in SQL SERVER.

   WITH MAXSALAY_CTE
   AS
   (
   Select Max(Salary) as MaxSalary from Employee A (Nolock)
   where n=(select count(distinct(Salary)) from Employee B (Nolock)
   where B.Salary>=A.Salary)
   )
   SELECT * FROM MAXSALAY_CTE

Comments are closed.