1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

-- @Title: 第N高的薪水 (Nth Highest Salary)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 15:42:14
-- @Runtime: 229 ms
-- @Memory: 0 B
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
set n = N-1;
  RETURN (
      # Write your MySQL query statement below.
      select (
          select distinct  Salary 
          from Employee
          Order by Salary desc
          limit n,1
      )
  );
END