176. Second Highest Salary

/* Write your T-SQL query statement below */
SELECT  MAX(salary) AS SecondHighestSalary
FROM Employee
WHERE salary < (
SELECT  MAX(salary)
FROM Employee);