176. Second Highest Salary
Solution Code
MySQL
SELECT MAX(Salary) as 'SecondHighestSalary'
FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee);
SELECT MAX(Salary) as 'SecondHighestSalary'
FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee);