ANY

Syntax

ANY( value )

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

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:

• value — Any

Return type: Same type as (value)

Example

ANY([Profit])

Data source support

ClickHouse 19.13, MySQL 5.7.