Range Conditions

A range condition tests for inclusion in a range.

range_conditions::=

Description of range_conditions.gif follows
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;