IS NULL Predicate

noun

say it: “IZ NUL PRED-ih-kit” /ɪz nʌl ˈprɛdɪkɪt/

A SQL condition that checks whether a value is missing, written IS NULL or IS NOT NULL.

What does IS NULL Predicate do in a relational database?

IS NULL Predicate — A predicate testing whether a value is NULL.

SELECT customer_id
FROM customer
WHERE phone_number IS NULL;

In a sentence

  • “WHERE Region IS NULL finds the customers with no region.”

Level: Apprentice · More SQL terms at this level

Updated