How to find third highest salary in SQL?

Question

Can you explain how to find the third highest salary in SQL?

Answer 1

Here is the query to find out the third highest salary of all the employees. You can replace the value of 3 with any number to find out that particular highest salary of the table. This is a frequently asked question in interviews and you can read this SQL interview questions blog for more FAQs and how to answer them.

select e1.EmployeeName from Employee as e1

where 3 = (select count (*)

      from Employee e2

      where e2.salary >= e1.salary)