Back
Can anyone tell me how to find the second highest salary in SQL?
The following is the query to find the second-highest salary of the employee in SQL. This is one of most frequently asked question in SQL interview and you can check out this blog on SQL interview questions for more such FAQs in the interview.
select e1.EmployeeName from Employee as e1where 2 = (select count (*) from Employee e2 where e2.salary >= e1.salary)
select e1.EmployeeName from Employee as e1
where 2 = (select count (*)
from Employee e2
where e2.salary >= e1.salary)
31k questions
32.8k answers
501 comments
693 users
Back
Back