CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
DECLARE m INT;
set m = N-1;
RETURN (
# Write your MySQL query statement below.
SELECT IFNULL((
SELECT DISTINCT Salary
FROM Employee
ORDER BY Salary DESC
LIMIT m,1),null)
);
END
题解来自
作者:zheng-cheng-xiang
链接:https://leetcode-cn.com/problems/nth-highest-salary/solution/zhu-yi-limityong-fa-by-zheng-cheng-xiang-7ncw/
来源:力扣(LeetCode)
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。
关于变量定义可参考:
https://blog.csdn.net/fanhl111/article/details/89644540