My soution


  • 0
    Y

    SELECT MAX(Salary) SecondHighestSalary FROM employee e
    WHERE 1=
    (SELECT COUNT(*)
    FROM employee
    WHERE Salary>e.Salary
    );


Log in to reply
 

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