Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Syntax

GROUPCONCATDISTINCT(<any>[; <number>])

Description

Concatenates all non-null values seen in a group. The first argument is the column containing values that should be concatenated. The second value is an optional constant used to set a maximum number of values to avoid overflow problems with very large groups. The maximum number of values defaults to 1000. If more than the configured maximum number n of values are seen, the top n values in ascending order are kept.
The concatenated values are returned as a list

This is an aggregate function

...

Info

 This function returns a list. If you require a JSONrepresented as a string, wrap this function in TOJSON (E.g., TOJSON(<function>(...)).

...