IN Predicate
noun
say it: “IN PRED-ih-kit” /ɪn ˈprɛdɪkɪt/
A SQL condition that checks whether a value matches any value in a list, like Country IN ('UK', 'USA').
What does IN Predicate do in a relational database?
IN Predicate — A predicate testing whether a value equals any value in a list or subquery result.
SELECT order_id
FROM purchase_order
WHERE status IN ('open', 'processing');
In a sentence
- “WHERE Country IN ('UK', 'USA') replaced two ORs.”
Level: Apprentice · More SQL terms at this level
Updated