BETWEEN Predicate

noun

say it: “bih-TWEEN PRED-ih-kit” /bɪˈtwiːn ˈprɛdɪkɪt/

A SQL condition that checks whether a value lies in a range, including both ends.

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;

In a sentence

  • “UnitPrice BETWEEN 10 AND 20 includes products costing exactly $10 and $20.”

Level: Apprentice · More SQL terms at this level

Updated