# BETWEEN Predicate

A predicate testing whether a value falls within an inclusive lower and upper bound.

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

**BETWEEN Predicate** — A predicate testing whether a value falls within an inclusive lower and upper bound.

```sql
SELECT order_id
FROM purchase_order
WHERE total_amount BETWEEN 50 AND 100;
```

Level: Apprentice · [More Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/apprentice)

Updated: September 27, 2026

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