LeetCode | MySQL | 177. Nth Highest Salary

177. Nth Highest Salary

leetcode.com/problems/nth-highest-salary/

Nth Highest Salary - LeetCode

 

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
    RETURN(
        SELECT IF(COUNT(sub.Salary) < N, NULL, MIN(sub.Salary))
        FROM(
            SELECT DISTINCT e.Salary
            FROM Employee AS e
            ORDER BY Salary DESC
            LIMIT N
            )sub
    );
END