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
《L03 构架 API 服务器》
你将学到如 RESTFul 设计风格、PostMan 的使用、OAuth 流程,JWT 概念及使用 和 API 开发相关的进阶知识。
《L01 基础入门》
我们将带你从零开发一个项目并部署到线上,本课程教授 Web 开发中专业、实用的技能,如 Git 工作流、Laravel Mix 前端工作流等。
讨论数量: 0
(= ̄ω ̄=)··· 暂无内容!

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