第N高的薪水
一、题目
二、解析
参考第176题,求解第二高的薪水,只不过此题需要考虑N=0的情况,N=0时,同样返回NULL
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
SET N = N-1;
IF N < 0 THEN
RETURN NULL;
ELSE
RETURN (
# Write your MySQL query statement below.
SELECT(
SELECT
DISTINCT Salary
FROM Employee
ORDER BY Salary DESC
LIMIT N, 1
)
AS getNthHighestSalary
);
END IF;
END