Skip to main content

ANY

Aggregate function.

The ANY() function selects the first encountered (non-NULL) value, unless all rows have NULL values in that column. The query can be executed in any order and even in a different order each time, so the result of this function is indeterminate. To get a determinate result, you can use the ‘min’ or ‘max’ function instead of ‘any’.

Syntax

ANY(expression)

Arguments

ArgumentsDescription
expressionAny expression

Return Type

The first encountered (non-NULL) value, in the type of the value. If all values are NULL, the return value is NULL.

Examples

tip
numbers(N) – A table for test with the single `number` column (UInt64) that contains integers from 0 to N-1.
SELECT ANY(number) FROM numbers(3);
+-------------+
| any(number) |
+-------------+
| 0 |
+-------------+

-- Table t1:
-- +------+
-- | a |
-- +------+
-- | NULL |
-- | NULL |
-- | 1 |
-- | 2 |
-- | NULL |
-- | 3 |
-- +------+
SELECT ANY(a) FROM t1;
+--------+
| any(a) |
+--------+
| 1 |
+--------+

-- Table t2:
-- +------+
-- | a |
-- +------+
-- | NULL |
-- | NULL |
-- | NULL |
-- +------+
SELECT ANY(a) FROM t1;
+--------+
| any(a) |
+--------+
| NULL |
+--------+