Solution for Nth Highest Salary


  • 0
    L

    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
    ORDER BY Salary DESC
    LIMIT 1 OFFSET N), NULL)
    );
    END;


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.