Second Highest Salary

SELECT MAX(salary) AS SecondHighestSalary
FROM (
  SELECT salary
  FROM Employee
  WHERE salary < (SELECT MAX(salary) FROM Employee)
) AS derived_table;