LeetCode 数据库 176. 第二高的薪水

原题链接

代码语言：javascript复制

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

ode

0 人点赞