2nd, 3rd, Nth Highest Salary In SQL Server 2008

In this article I will explain, how to find 2nd,3rd, nth highest salary in sql server.
  • 7429


In SQL Server we have the concept about sub queries. Sub queries means query within the query. Lets take a example of sub query. Suppose we want to find out the nth largest salary among the given salaries so for this purpose we have to use sub query.

Lets have a look on the following example.

I have created Employee table with following values.

1st method

To select 2nd highest salary or record we can use following query.




2nd method

To select 3rd highest salary or record we can use following query.


3rd method

To select nth largest salary or record from above table, we can use following query.

select top 1 salary from (select distinct top n salary from Employee order by salary desc) a order by salary


More Articles

© 2020 DotNetHeaven. All rights reserved.