SQL Language Guide > SQL Language Guide > Elements of SQL Statements > Predicates in SQL > BETWEEN Predicate
Was this helpful?
BETWEEN Predicate
The following table explains the operators BETWEEN and NOT BETWEEN:
Operator
Meaning
y BETWEEN [ASYMMETRIC] x AND z
x < = y and y < = z
y NOT BETWEEN [ASYMMETRIC] x AND z
not (y between x and z)
y BETWEEN SYMMETRIC x AND z
(x < = y and y < = z) or (z < = y and y < = x)
y NOT BETWEEN SYMMETRIC x AND z
not (y between symmetric x and z)
x, y, and z are expressions, and can include subqueries.
Last modified date: 11/09/2022