176. 第二高的薪水
题目链接:176. 第二高的薪水
代码如下:
# Write your MySQL query statement below
select ifnull(
(select distinct salary from Employee
order by salary Desc
limit 1 offset 1),
null
) as SecondHighestSalary
题目链接:176. 第二高的薪水
代码如下:
# Write your MySQL query statement below
select ifnull(
(select distinct salary from Employee
order by salary Desc
limit 1 offset 1),
null
) as SecondHighestSalary