IN versus EXISTS - are they the same?
Intermediate level video on Structured Query Language.
The IN and EXISTS operators are sometimes viewed as "equivalent". They serve a similar purpose and are sometimes used to produce the same records. However, their underlying mechanisms are quite different. This example using the Northwind database demonstrates how NULLs are treated differently when using NOT IN versus NOT NULL.
Watch video IN versus EXISTS - are they the same? online without registration, duration hours minute second in high quality. This video was added by user Database by Doug 20 November 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,680 once and liked it 108 people.