[LeetCode][SQL]Nth Highest Salary
标签：
[LeetCode][SQL]Nth Highest Salary
#drop function getNthHighestSalary$$
2 CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
3 BEGIN
4 DECLARE M INT;
5 SET M = N - 1;
6 RETURN (
7 select distinct Salary from Employee order by Salary desc limit M, 1
8 );
9 END