LeetCode·Database·求得第二高薪水

ToBeOrNotToBe_Up

于 2019-04-30 15:47:56 发布

阅读量152

点赞数 2

CC 4.0 BY-SA版权

分类专栏：数据库 LeetCode题库文章标签： LeetCode Database Mysql

16 篇文章

订阅专栏

2 篇文章

订阅专栏

题目版权归LeetCode所有详情参考:https://leetcode.com/problems/second-highest-salary/
题目如下：Second Highest Salary

SELECT (SELECT DISTINCT Salary FROM Employee 
    ORDER BY Salary DESC 
    LIMIT 1 OFFSET 1) AS SecondHighestSalary

2.保险起见，加“判空”

SELECT 
  IFNULL(
    (SELECT DISTINCT Salary FROM Employee 
    ORDER BY Salary DESC 
    LIMIT 1 OFFSET 1 
    ),
    NULL) AS SecondHighestSalary

3.比较输出

SELECT MAX(Salary) AS SecondHighestSalary
FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee)

注：参考：https://blog.youkuaiyun.com/xxzhangx/article/details/78169729