176. Second Highest Salary

select max(Salary) as SecondHighestSalary
from Employee
where Salary < (select max(Salary)
from Employee);

posted @ 2018-12-18 03:04  yuesi  阅读(77)  评论(0编辑  收藏  举报