Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Conditions, 6 of 13
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 |
SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000; |
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|