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
转载于:https://my.oschina.net/u/3424826/blog/1843490
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
转载于:https://my.oschina.net/u/3424826/blog/1843490