Comparison Predicate
noun
say it: “kum-PAIR-ih-sun PRED-ih-kit” /kəmˈpærɪsən ˈprɛdɪkɪt/
A condition that compares two values in SQL with =, <>, <, >, <= or >=.
What does Comparison Predicate do in a relational database?
Comparison Predicate — A condition comparing values with operators such as =, <>, <, or >=.
SELECT order_id
FROM purchase_order
WHERE total_amount >= 100 AND status = 'open';
In a sentence
- “UnitPrice > 50 is a comparison predicate that keeps the expensive products.”
Level: Novice · More SQL terms at this level
Updated