How would I find the second largest salary from the employee table? [closed]

April 11, 2024 by Tarik

Try this:

SELECT max(salary)
FROM emptable
WHERE salary < (SELECT max(salary)
                FROM emptable);