17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
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.