Diagram explaining NULL as unknown and showing how comparisons with NULL return unknown
SQL

NULL in SQL Explained Simply: IS NULL, COALESCE and Common Traps

/

Understand what NULL means in SQL, why = NULL never works, and how to handle missing values with IS NULL, COALESCE and NULLIF.