Back

Explore Courses Blog Tutorials Interview Questions

How to find nth highest salary in SQL?

0 votes
2 views
in SQL by (55.6k points)

Can you please tell me how to find nth highest salary in SQL?

1 Answer

0 votes
by (119k points)

The following is the query to find the nth highest salary from a table in SQL. This is the most commonly asked question in the interviews and you can read this SQL interview questions blog for more such FAQs in the SQL interview.

select e1.EmployeeName from Employee as e1

where n = (select count (*)

      from Employee e2

      where e2.salary >= e1.salary)

Related questions

0 votes
1 answer
How to find third highest salary in SQL?
asked Apr 21, 2020 in SQL by Sudhir_1997 (55.6k points)
0 votes
1 answer
How to find second highest salary in SQL?
asked Apr 20, 2020 in SQL by Sudhir_1997 (55.6k points)
0 votes
1 answer
How to find top three highest salary in emp table in oracle?
asked Dec 12, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
How to find out 2nd highest salary of employees?
asked Jan 3, 2021 in SQL by Appu (6.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...