Accepted ,Two Method ,But Runtime need to optimize


  • -1
    L
    select c.Name as Customers  from Customers c LEFT JOIN Orders o ON c.id = o.CustomerId where o.Id is null
    
    
    
    select  c.Name as Customers   from  Customers c where  c.Id not in ( select CustomerId from Orders )

Log in to reply
 

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