177 - Nth Highest Salary

最新推荐文章于 2025-04-25 16:58:42 发布

原创最新推荐文章于 2025-04-25 16:58:42 发布 · 457 阅读

0 ·

CC 4.0 BY-SA版权

LeetCode 专栏收录该内容

41 篇文章

订阅专栏

本文介绍如何使用SQL查询获取员工表中第N高的薪资。通过利用MySQL的LIMIT子句来实现这一目标，并提供了一个具体的函数示例。

Write a SQL query to get the nth highest salary from the Employee table.

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

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

Subscribe to see which companies asked this question

思路分析：

mysql支持limit
select * from tablename limit 0,1
即取出第一条记录。

select * from tablename limit 1,1
第二条记录

select * from tablename limit 10,20
从第11条到31条（共计20条）

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