ANY

Aggregate functions

Syntax

ANY( value )

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)

Examples

ANY([Profit])

Data source support

Materialized Dataset, ClickHouse 1.1, MySQL 5.7.