# 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 =, &lt;>, &lt;, >, &lt;= or >=.

## What does **Comparison Predicate** do in a relational database?

**Comparison Predicate** — A condition comparing values with operators such as =, <>, <, or >=.

```sql
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](https://www.ask-codey.com/glossary?category=sql&level=1)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/comparison-predicate
