SQL NULL and three-valued logic: the NOT IN trap

Why comparisons with SQL NULL return UNKNOWN in three-valued logic, why WHERE drops them, and why NOT IN with one NULL returns no rows.

Part of Relational queries.

Read first

Read next

Related