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  弦断  阅读(107)  评论(0编辑  收藏  举报