编写一个 SQL 查询,获取 Employee
表中第 n 高的薪水(Salary)。
思路和176一样,只不过多了如何在sql语句中加入变量
代码如下:
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
declare m INT;
set m=N-1;
RETURN (
# Write your MySQL query statement below.
select
(select distinct Salary
from Employee
order by Salary desc
limit m,1)
);
END
结果: