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