Why the following code is giving runtime error please see.


  • 0
    A

    CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
    BEGIN
    RETURN (
    # Write your MySQL query statement below.
    select Max(Salary) from T where salary (SELECT TOP N Salary FROM Employee ORDER BY Salary ASC)
    );
    END


Log in to reply
 

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