A.4.1 Between Operator
The 'between' comparison is shorthand for a 'greater than or equal to' and a 'less than or equal to' expression.
salary between 30000 and 40000
This is equivalent to the following condition.
salary >= 30000 and salary <= 40000
A negative 'between' comparison can be created using 'not between'.
salary not between 30000 and 40000
| << A.4 SQL Predicates | © 1996-2013 InetSoft Technology Corporation (v11.4) | A.4.2 In Operator >> |