LeetCode.177. 第N高的薪水
思路:
由于n不确定,因此不可再参考第二高薪水中的优化思路,只可先排序后取值。
代码:
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 1 offset m
);
END