BETWEEN

Operators

Syntax

value [ NOT ] BETWEEEN low AND high

Description

Returns TRUE if value is in the range from low to high.

The option value NOT BETWEEEN low AND high returns the opposite value.

Argument types:

• value — Date | Datetime | Number | String
• low — Date | Datetime | Number | String
• high — Date | Datetime | Number | String

Return type: Boolean

Examples

3 BETWEEN 1 AND 100 = TRUE

3 NOT BETWEEN 1 AND 100 = FALSE

Data source support

Materialized Dataset, ClickHouse 1.1, Yandex.Metrica, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.