leetcode 177. Nth Highest Salary

最新推荐文章于 2021-07-03 16:48:47 发布

星_尘

最新推荐文章于 2021-07-03 16:48:47 发布

阅读量972

点赞数

分类专栏： LeetCode 文章标签： leetcode

本文链接：https://blog.csdn.net/travel_1/article/details/51589647

版权

LeetCode 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

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.

leetcode 176题的扩展版,

看到这题才知道SQL的如何定义变量和函数

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  declare M INT;  
  set M=N-1;
  RETURN (
      select distinct Salary 
      from Employee
      order by Salary DESC
      limit M,1
  );
END