176.md

Second Highest Salary]

Description

link

---

Solution

See Code

---

Code

# Write your MySQL query statement below
SELECT max(Salary) as SecondHighestSalary
FROM Employee
WHERE Salary < (SELECT max(Salary) FROM Employee)