Can you explain how to find the third highest salary in SQL?
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 e1where 3 = (select count (*) from Employee e2 where e2.salary >= e1.salary)
select e1.EmployeeName from Employee as e1
where 3 = (select count (*)
from Employee e2
where e2.salary >= e1.salary)