SELECT 2nd highest salary in the employee table.

SELECT MAX(Salary)
FROM   Employee
WHERE  Salary NOT IN ( SELECT MAX(Salary)
                       FROM Employee )