Comparison

    Syntax

    Equality

    value_1 = value_2
    

    Inequality

    value_1 != value_2
    

    Less than

    value_1 < value_2
    

    Less than or equal

    value_1 <= value_2
    

    Greater than

    value_1 > value_2
    

    Greater than or equal

    value_1 >= value_2
    

    Description

    Compares the value value_1 with the value value_2.

    Argument types:

    • value_1Array of fractional numbers | Array of integers | Array of strings | Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID
    • value_2Array of fractional numbers | Array of integers | Array of strings | Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID

    Return type: Boolean

    Note

    Due to implementation details of the Fractional number type in ClickHouse sources it is recommended to use the COMPARE function instead of comparison operators for this type.

    Examples

    1 = 1 = TRUE
    
    7 > 2 > 1 = TRUE
    

    Data source support

    ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.