Gcobani Mkontwana

Gcobani Mkontwana

  • 1k
  • 1.4k
  • 168.5k

How to explain this logic and ways to avoid?

Nov 11 2020 1:21 PM
Hi Team
 
I have this query, how do you explain this result and ways to avoid that it does not happen in sql server.?
  1. SELECT * FROM runners WHERE id NOT IN (SELECT winner_id FROM races)  
  2.   
  3. // output  
  4.   
  5. Id column empty  
  6. name column empty  
 

Answers (4)