What does the condition WHERE price = NULL match?

Question

Accepted Answer

Nothing, because the comparison evaluates to unknown — Comparing anything to NULL yields unknown, and WHERE keeps only rows where the condition is true — so = NULL silently matches nothing rather than erroring, which is what makes it a hard bug to spot. IS NULL is the test that works.

Answer

Every row whose price column has no value stored

Answer

Every row, because = NULL is always taken as true

Answer

Every row whose price is zero or has no value at all

What does the condition WHERE price = NULL match?

Why this is the answer

More SQL Fundamentals flashcards