What's improved on this solution?


  • 0
    M

    select if(count(*)=0,null,t1.Salary) as Salary from (select * from Employee t3 where Salary < (Select Max(t2.Salary) from Employee t2) order by t3.Salary desc limit 1) t1


Log in to reply
 

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