SQL · Aggregation and grouping

string_agg / group_concat

Joins group values into one string. SQLite calls it group_concat.

sqlRunnable example sql course

Syntax

string_agg(column, ', ')

Example

Open in the lab

WITH lessons(course, title) AS (VALUES ('HTML', 'Intro'), ('HTML', 'Forms'))
SELECT course, group_concat(title, ', ') AS lessons FROM lessons GROUP BY course;

Learn this in the course

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

Open the course

string_agg / group_concat

Example

More in this group

Learn this in the course