177. Nth Highest Salary


  • 0
    T

    CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
    BEGIN

    DECLARE offsetval INT;
    SET offsetval = N-1;

    RETURN (
    # Write your MySQL query statement below.
    SELECT DISTINCT
    Salary
    FROM
    Employee
    ORDER BY Salary DESC
    LIMIT 1 OFFSET offsetval

    );
    END


Log in to reply
 

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