SQL · Aggregate functions

string_agg()

Concatenates group values with a delimiter. PostgreSQL and SQL Server.

sqlRunnable example sql course

Syntax

string_agg(expression, delimiter)

Example

Open in the lab

-- PostgreSQL: SELECT string_agg(title, ', ') FROM lessons;
WITH lessons(title) AS (VALUES ('HTML'), ('CSS'))
SELECT group_concat(title, ', ') AS titles FROM lessons;

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()

Example

More in this group

Learn this in the course