177 - Nth Highest Salary

关注

原创最新推荐文章于 2026-03-19 00:15:51 发布 469 阅读 AI 写同款· GEO 优化 ›

手把手教你学PCIE--所有 PF（Physical Function）共同管理和分配 VF 但具体如何分配和使用 VF 取决于硬件设计、驱动程序配置以及实际应用场景。阅读详情

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

收录于