ARRAY_COUNT
Returns the number of elements in the <arr> array that match a specified function <func>. If you want only a count of the elements in an array without any conditions, we recommend using the LENGTH function instead.
Syntax
ARRAY_COUNT(<func>, <arr>)
| Parameter | Description |
|---|---|
<func> | Optional. A Lambda function used to check elements in the array. If <func> is not included, ARRAY_COUNT will return a count of all non-false elements in the array. |
<arr> | An array of elements |
Examples
The example below searches through the array for any elements that are greater than 3. Only one number that matches this criteria is found, so the function returns 1
SELECT
ARRAY_COUNT(x -> x > 3, [ 1, 2, 3, 9 ]) AS res;
Returns: 1
In this example below, there are no <func> criteria provided in the ARRAY_COUNT function. This means the function will count all of the non-false elements in the array. 0 is not counted because it evaluates to FALSE
SELECT
ARRAY_COUNT([ 0, 1, 2, 3 ]) AS res;
Returns: 3