How to find second highest salary from table

Question

Manish Kumar · Answer

there are many ways to solve this problem one of them is
select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee
and anotother is 
SELECT TOP 1 salary FROM (
and  and SELECT TOP 2 salary 
and  and FROM employees 
and  and ORDER BY salary DESC) AS emp 
ORDER BY salary ASC

interview

How to find second highest salary from table

Manish Kumar

Can you answer this question?

1 Answers

Liked By