INTERSECT and EXCEPT: Where NULL Finally Behaves

· by · in

INTERSECT and EXCEPT treat NULL as equal, the one place NULL comparison behaves as expected. Use them for NULL-safe row comparison.