The BETWEEN test is satisfied if the following condition is true.
expression_2 <= expression_1 <= expression_3
If the BETWEEN test fails, no rows are returned.
The BETWEEN test is treated as two separate logical comparisons.
expression_1 >= expression_2 AND expression_1 <= expression_3.
| Expression | Equivalent Expression |
|---|---|
| x BETWEEN y AND z | ((x >= y) AND (x <=z)) |
Because expression_1 is evaluated twice, using a nondeterministic function, such as RANDOM, can produce unexpected results.