ANY
Syntax
Standard
Extended
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:
value—Any
Return type: Same type as (value)
Example
ANY([Profit])Data source support
ClickHouse 21.8, MySQL 5.7, YDB.
Previous
Next