ANY

SyntaxSyntax

ANY( value )

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

DescriptionDescription

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:

• value — Any

Return type: Same type as (value)

ExampleExample

ANY([Profit])

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, MySQL 5.7, Trino, Yandex Documents, YDB.