NULL

SQL's marker for a missing or unknown value, which is not zero, not empty text and not equal to anything, even another NULL.

In more detail

Any comparison with NULL, including NULL = NULL, gives unknown rather than true, so a filter written with = NULL keeps no rows. Test for it with IS NULL. Most aggregates skip NULLs, and an outer join produces NULLs for the columns of rows that had no match.

Related terms

Taught in

References

Certification courses