# 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.

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

Updated: November 9, 2026

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