CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
declare y int;
set y = n-1;
RETURN (
# Write your MySQL query statement below.
select ifnull((select distinct salary from
employee order by salary
desc limit y,1),null) as getNthHighestSalary
);
END
思路:先去重,按照薪水倒序,第一高的薪水起始索引是0,以此类推,所以n -1 得出所在的位置。