176. Second Highest Salary

问题描述

解决方案

select
(
select Salary from Employee
union
select null 
order by Salary desc
limit 1,1
) SecondHighestSalary
 

posted @ 2016-08-11 11:25  弦断  阅读(111)  评论(0)    收藏  举报