Reference material for ARRAY_COUNT_DISTINCT function
COUNT
and COUNT(DISTINCT ...)
aggregations, NULL
is not counted as a value if it occurs.
Parameter | Description | Supported input types |
---|---|---|
<array> | The array of which to count the distinct elements. | Any ARRAY type |
INTEGER
4