ANY
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
.