How to Find the second highest salary in SQL?


 Find the second highest salary:

SELECT MAX(SALARY) FROM EMPLOYEE 
WHERE SALARY NOT IN (SELECT MAX(SALARY) FROM EMPLOYEE) 




Post a Comment

0 Comments