Home > Articles > .Net Framework Articles > How to find third highest salary in sql server.

How to find third highest salary in sql server.

by vikash kumar   on Jan 29, 2016   Category: .Net Framework  | Level: Intermediate  |  Views: 988    |  Points: 100   
Like this article? Bookmark and Share:
To find the third highest salary in sql server


select max(salary) from tblEmployee where salary not in(select distinct top 2 salary from tblEmployee order by salary desc)

Note :- Here tblEmployee is the name of table and salary is the column.


Like this article? Bookmark and Share:

Most viewed Articles

User Comments


No response found, be the first to review this article.

Submit feedback about this article

Please sign in to post feedback

Latest Posts