IS NULL vs = NULL

Question

IS NULL vs = NULL

Accepted Answer

IS NULL is the only correct way to test for a NULL value. manager_id = NULL is UNKNOWN for every row - even the row where manager_id is actually NULL - because NULL is not equal to anything, including itself. IS NULL bypasses this and correctly identifies the NULL row.