ANY

    Syntax

    ANY( value )
    
    ANY( value
         [ FIXED ... | INCLUDE ... | EXCLUDE ... ]
         [ BEFORE FILTER BY ... ]
       )
    

    More info:

    Description

    Returns one of the values of value from the group. This is a nondeterministic aggregation — the result may vary for the same data over multiple queries.

    Argument types:

    • valueAny

    Return type: Same type as (value)

    Example

    ANY([Profit])
    

    Data source support

    ClickHouse 19.13, MySQL 5.7.