Language Reference Guide : Language Elements : Predicates in SQL : BETWEEN Predicate
 
Share this page          
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.