Language Reference Guide > Language Reference Guide > Language Elements > 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 asymmetric x and z
not (y between symmetric x and z)
x, y, and z are expressions, and cannot be subqueries.
Last modified date: 06/25/2024