The Answer of FB's SQL Question

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  
本作品采用《CC 协议》,转载必须注明作者和本文链接
Wayne
《L04 微信小程序从零到发布》
从小程序个人账户申请开始,带你一步步进行开发一个微信小程序,直到提交微信控制台上线发布。
《L02 从零构建论坛系统》
以构建论坛项目 LaraBBS 为线索,展开对 Laravel 框架的全面学习。应用程序架构思路贴近 Laravel 框架的设计哲学。
讨论数量: 0
(= ̄ω ̄=)··· 暂无内容!

讨论应以学习和精进为目的。请勿发布不友善或者负能量的内容,与人为善,比聪明更重要!