Range Conditions

A range condition tests for inclusion in a range.

range_conditions::=

Description of the illustration range_conditions.gif

Table 7-9 describes the range conditions.

Table 7-9 Range Conditions

Type of Condition	Operation	Example
[NOT] BETWEEN x AND y	[Not] greater than or equal to `x` and less than or equal to `y`.	SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000 ORDER BY employee_id;