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
|