Logical Predicate
noun
say it: “LOJ-ih-kul PRED-ih-kit” /ˈlɒdʒɪkəl ˈprɛdɪkɪt/
A SQL condition that combines or reverses others with AND, OR and NOT.
What does Logical Predicate do in a relational database?
Logical Predicate — A condition that combines or reverses other conditions with AND, OR, or NOT.
SELECT order_id
FROM purchase_order
WHERE total_amount >= 100 AND status = 'open';
In a sentence
- “The logical predicate Country = 'UK' AND City = 'London' needs both to be true.”
Level: Novice · More SQL terms at this level
Updated