Not in vs Not Exists

They both (“NOT IN” and “NOT EXIST”) have the same functionality with only one major difference:

"NOT IN" will return a "NULL" if there are any NULL column(s) in the subquery.
"NOT EXISTS" does not do that so if you want to be consistent always use "NOT EXISTS"


Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn