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.

SELECT order_id
FROM purchase_order
WHERE total_amount BETWEEN 50 AND 100;

Level: Apprentice · More Database terms at this level

Updated September 27, 2026