题目3：MySQL----------Nth Highest Salary

最新推荐文章于 2025-04-16 22:30:20 发布

原创最新推荐文章于 2025-04-16 22:30:20 发布 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #database #Nth Highest Salary

数据库MySQL 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了一种使用SQL查询获取员工表中第N高的薪资的方法。通过编写MySQL存储过程来实现这一目标，解决了直接查询的复杂性。当N等于2时，例如，返回第二高的薪资为200。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.

题目解答：

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