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:

    • valueDate | Datetime | Fractional number | Integer | String
    • lowDate | Datetime | Fractional number | Integer | String
    • highDate | 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.