CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
set N = N - 1;
RETURN (
# Write your MySQL query statement below.
select distinct salary from Employee order by salary desc limit 1 offset N
);
END
第N高的薪水 [sql]
最新推荐文章于 2024-09-09 23:37:05 发布