Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Conditions, 6 of 11
A range condition tests for inclusion in a range.
range_condition::=
range_condition
Table 5-8 describes the range conditions.
Condition | Operation | Example |
---|---|---|
[NOT] BETWEEN x AND y |
[Not] greater than or equal to |
SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000; |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|