Range Conditions

A range condition tests for inclusion in a range.

range_condition::=

Text description of range_condition

Table 5-8 describes the range conditions.

Table 5-8 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;