Answers for "query to find third highest salary"

query to find third highest salary

-*FOR THIRD HIGHEST SALARY*

Select top 1 from (select top 3 salary from emp order by salary desc)
order by asc

Posted by: Guest on April-26-2022

query to find second highest salary

SELECT MAX(SALARY) FROM Employee WHERE SALARY < (SELECT MAX(SALARY) FROM Employee)

Posted by: Guest on April-26-2022

Code answers related to "query to find third highest salary"