题目描述：

Write a SQL query to get the n^th highest salary from the Employee table.

+----+--------+
| Id | Salary |
+----+--------+
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |
+----+--------+

For example, given the above Employee table, the n^th highest salary where n = 2 is 200. If there is no n^th highest salary, then the query should return null.

题目大意：

编写SQL查询获取雇员表中的第n高薪水值。

例如，给定上面的雇员表，当n为2时，第n高薪水为200.如果没有第n高薪水，查询返回null。

解题思路：

使用LIMIT和ORDER BY

SQL语句：

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
DECLARE M INT;
SET M=N-1;
  RETURN (
      # Write your MySQL query statement below.
      SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT M, 1
  );
END

参阅LeetCode Discuss：https://oj.leetcode.com/discuss/21311/accpted-solution-for-the-nth-highest-salary

本文链接：http://bookshadow.com/weblog/2015/01/13/leetcode-nth-highest-salary/
请尊重作者的劳动成果，转载请注明出处！书影博客保留对文章的所有权利。

如果您喜欢这篇博文，欢迎您捐赠书影博客： ，查看支付宝二维码