问题描述
https://leetcode.com/problems/nth-highest-salary/
代码
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
DECLARE m INT;
SET m = n - 1;
RETURN (
# Write your MySQL query statement below.
SELECT Salary
FROM Employee
GROUP BY Salary
ORDER BY Salary DESC
LIMIT m, 1
);
END
复杂度分析
- 时间复杂度：
- 空间复杂度：
