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.
|This expression …||Is equivalent to …|
|x BETWEEN y AND z||((x >= y) AND (x <=z))|
Note that because expression_1 is actually evaluated twice, using a nondeterministic function, such as RANDOM, can produce unexpected results.