菜单 学习猿地 - LMONKEY

VIP

开通学习猿地VIP

尊享10项VIP特权 持续新增

知识通关挑战

打卡带练!告别无效练习

接私单赚外块

VIP优先接,累计金额超百万

学习猿地私房课免费学

大厂实战课仅对VIP开放

你的一对一导师

每月可免费咨询大牛30次

领取更多软件工程师实用特权

入驻
3194
0

The Answer of FB's SQL Question

原创
05/13 14:22
阅读数 2901

Write a SQL query to get the second highest salary from the Employee table.
file
For example, given the above Employee table, the query should return 200 as the second highest salary. If these is no second highest salary, then the query should return null.
file

Unofficial Answer:

SELECT MIN(v.Salary) FROM Employee AS v INNER JOIN (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT 2) AS v2 ON v.Salary = v2.Salary  
SELECT MIN(v2.Salary) AS v FROM (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT 2) AS v2  

发表评论

0/200
3194 点赞
0 评论
收藏
为你推荐 换一批