17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.