SQL · Aggregate functions

group_concat()

Joins values from a group into one string. SQLite name for string_agg.

sqlRunnable example sql course

Syntax

group_concat(expression, separator)

Example

Open in the lab

WITH lessons(course) AS (VALUES ('HTML'), ('CSS'))
SELECT group_concat(course, ', ') AS courses FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.