Query to find 2nd largest salary from Employees

• Use ORDER BY and LIMIT

• Exclude the highest salary using subquery

• Handle cases where there are ties

SELECT MAX(SALARY)

FROM Employee

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