NULL

0001-01-01

NULL in SQL: Three-Valued Logic

NULL is not zero, not an empty string, not false. It means unknown — and that single word explains every surprising thing SQL does with it, from WHERE conditions that silently drop rows to comparisons that never return true.