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