array()

Creates an array of values that belong to the group. It collects up to 100 items for each group and creates an array as a set that may also have duplicate values.

If you want to extract all the unique sets of values that belong to a group, use the values() function.

Syntax

array(EXPR)
Required Parameter
EXPR
Expression of any type