BETWEEN in Teradata

The BETWEEN operator is used in a WHERE clause to select a range of data between two values.

Syntax:
test_expression [ NOT ] BETWEEN begin_expression AND end_expression


Example:
SELECT *
FROM suppliers
WHERE supplier_id BETWEEN 1000 AND 2000;

The above example is equivalent to the following example.
SELECT *
FROM suppliers
WHERE supplier_id >= 1000
AND supplier_id <= 2000;