1
2
3
4
5
6
7
8
| CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
SET N := N-1;
RETURN (
# Write your MySQL query statement below.
SELECT IFNULL((SELECT DISTINCT salary FROM Employee e ORDER BY salary DESC LIMIT N, 1), NULL) AS 'SecondHighestSalary'
);
END
|