select max(Salary) as SecondHighestSalary
from Employee
where Salary < (select max(Salary)
from Employee);
176. Second Highest Salary
https://github.com/qixing810/leetcode_database
select max(Salary) as SecondHighestSalary
from Employee
where Salary < (select max(Salary)
from Employee);