This is can be any expression containing the keyword element and returning any simple type except Blob. The resulting (grouped) array is an array of type Group, where values contains the array elements that belong into that group.
The group-by clause (group by
<group-by-expression>
) is optional. The group-by clause must not be used in conjunction with the distinct clause (distinct
<distinct-expression>
).