BETWEEN
Syntax
value [ NOT ] BETWEEN low AND high
Description
Returns TRUE if value is in the range from low to high.
The option value NOT BETWEEN low AND high returns the opposite value.
Argument types:
value—Date | Datetime | Fractional number | Integer | Stringlow—Date | Datetime | Fractional number | Integer | Stringhigh—Date | Datetime | Fractional number | Integer | String
Return type: Boolean
Examples
3 BETWEEN 1 AND 100 = TRUE
3 NOT BETWEEN 1 AND 100 = FALSE
Data source support
ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.
Previous
Next