Skip to main content

GROUP_CONCAT

Returns a string which is the concatenation of all non NULL values of an input column or grouping.

The order of the concatenated elements is arbitrary.

See also:
[SELECT]

Syntax​

SELECT GROUP_CONCAT(columnExpression [, separator]) FROM <multipartIdentifier>
[ GROUP BY groupByColumn ];

Arguments​

columnExpression
A column or expression. If * is specified then all records in the resource or grouping are counted.

At least one value from the columnExpression must be non NULL otherwise NULL is returned.

separator
Seperator used for the concatenated result, the default of , is used if separator is not specified.

groupByColumn
A column or columns used to perform summary or aggregate operations against. The GROUP BY clause returns one row for each column grouping.

Return Value(s)​

Returns a string as a list of values seperated by the separator or ,.

Examples​

Return a list of values for a column over an entire resource​

SELECT group_concat(name) as instance_list
FROM google.compute.instances 
WHERE project = 'stackql-demo' 
AND zone = 'australia-southeast1-a';

Return a list of values for a column expression grouped by another column expression​

SELECT tags, group_concat(name) as instance_list
FROM google.compute.instances 
WHERE project = 'stackql-demo' 
AND zone = 'australia-southeast1-a'
GROUP BY json_extract(tags, '$.instanceType');

For more information, see https://www.sqlite.org/lang_aggfunc.html#group_concat.