A range condition tests for inclusion in a range.
range_conditions::=
Table 7-9 describes the range conditions.
Table 7-9 Range Conditions
[NOT] BETWEEN x AND y
x
y
SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000;