GROUP_CONCAT
Concatenates values from a group into a single string with a separator.
Analyze Syntax
func.group_concat(<expr> [SEPARATOR '<sep>'])
Analyze Examples
func.group_concat(get_column(table, 'name'))
┌─────────────────────┐
│ 'Alice,Bob,Charlie' │
└─────────────────────┘
SQL Syntax
GROUP_CONCAT(<expr> [SEPARATOR '<sep>'])
SQL Examples
SELECT GROUP_CONCAT(name ORDER BY name SEPARATOR ', ') FROM employees;
┌─────────────────────┐
│ Alice, Bob, Charlie │
└─────────────────────┘