Conditions, 6 of 13

Range Conditions

A range condition tests for inclusion in a range.

range_condition::=

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