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.5) A.4.2 In Operator >>