Intuitive Solution


  • 0
    select max(Salary) as SecondHighestSalary
    from Employee
    where Salary < (select max(Salary) from Employee);
    

    When without 'as SecondHighestSalary', the judge told me:'You are Wrong!'. _(:зゝ∠)_


Log in to reply
 

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