176. Second Highest Salary.md

176. Second Highest Salary

Question Link

Solution

# Write your MySQL query statement below
select max(salary) SecondHighestSalary from Employee
where salary < (select max(salary) from Employee)