EXCEPT vs NOT EXISTS?!

EXCEPT removes rows from first set! It's like subtraction for result sets. NOT EXISTS does similar but differently. This set operation will confuse you!

#sql #sqltricks #except #notexists #setdifference #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #setoperations #advancedsql

https://www.youtube.com/watch?v=Nmnw6rkvzHI

Set Difference Operation Explained

Remove matching elements! The - operator with sets is genius. Watch the difference happen!

#python #pythontricks #setdifference #pythonsets #codingchallenge #pythonshorts

https://www.youtube.com/watch?v=xQ9L7Bi2WGQ