Why pass only 9 test cases


  • -1
    H

    CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
    BEGIN
    RETURN (
    # Write your MySQL query statement below.
    select Distinct e.Salary
    from Employee as e
    where N =
    (
    select Distinct Count(es.Salary)
    from Employee as es
    where e.Salary <= es.Salary
    )
    );
    END


Log in to reply
 

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