Glossary: SQL Beyond the Basics

Three-valued logic

Also written: unknown

Because comparisons with NULL give NULL, a SQL condition can be true, false or unknown. WHERE keeps a row only when the condition is true.