Using IFNULL


  • 0
    N
    select IFNULL((select distinct Salary from Employee
    order by Salary desc limit 1 offset 1),NULL) as SecondHighestSalary
    

Log in to reply
 

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