Two NULLs walk into a SELECT DISTINCT...

Question

Accepted Answer

For deduplication purposes, DISTINCT treats all NULLs as equal - multiple NULL values collapse into a single NULL row. The two NULL manager_id rows collapse to one. The distinct values are: NULL and 1. This is one case where NULL comparison behaves as equality, unlike WHERE where NULL = NULL is UNKNOWN.