NULL in SQL: explaining its behavior

Vertically, NULLs are not all identical. A Unique key against a nullable column will allow multiple NULLs