Upsolver SQLake
Contact Support
Search
⌃K
Links
Comment on page

COLLECT_SET_EACH

Collects a set of all values per group for a given field.

Syntax

COLLECT_SET_EACH([MAX_VALUES,] GROUP, VALUE)

Arguments

MAX_VALUES

Type: integer
Default: 2,147,483,647
(Optional) The maximum number of entries that are counted. When omitted, there is effectively no limit.

GROUP

Type: any
The field by which to group the results.

VALUE

Type: any
The field to be collected.

Returns

Type: array
Returns an array of key-value pairs where each GROUP is matched to the collected set of all values VALUE seen for that group.
Previous
COLLECT_SET
Next
COUNT
Last modified 1yr ago