BiruLyu
6/2/2017 - 4:23 AM

176. Second Highest Salary.sql

# Write your MySQL query statement below

SELECT MAX(E.Salary) AS SecondHighestSalary
FROM Employee AS E
WHERE E.Salary < (SELECT MAX(Salary) FROM Employee);