NOT IN, NOT EXISTS and MINUS: an aide-memoir

(Andrew Clarke) A colleague asked me whether NOT IN would return the same as MINUS. I said it would depend on whether the results contained nulls. I confess to not being clear as to how the results would be affected by the presence of nulls, but it’s easy enough to knock up a test case.

Read More - Register for Free Membership