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

mysql, sql, sql-server-2005

Solution

Try this:

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

Problem

How would I go about querying for the second largest salary from all employees in my Employee table?

Original source