How to find n’th highest salary from table in sql server

Select Max(Salary) from tblEmployee A (Nolock)
where n=(select count(distinct(Salary)) from tblEmployee B (Nolock) where B.Salary>=A.Salary)

Related posts:

  1. How to find Identity Column in SQL Server?
  2. What is difference between DISTINCT and GROUP BY?
  3. How to get max value in a row in SQL Server?
  4. How to get space acquired by a table in SQL Server?

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

  1. AvatarHitesh

    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. AvatarBabulal Sah

    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.