力扣---高频SQL题---46---176. 第二高的薪水

一、题目

二、代码

# Write your MySQL query statement below
select ifnull((
select salary as SecondHighestSalary  from Employee 
group by salary
order by salary desc      
limit 1 ,1
),null) as SecondHighestSalary 

-- select salary as SecondHighestSalary  from Employee 
-- group by salary
-- order by salary      
-- limit 1 ,1

三、运行结果