SQL Language Guide : 4. Elements of SQL Statements : 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 SYMMETRIC x AND z
not (y between symmetric x and z)
x, y, and z are expressions, and can include subqueries.