SQL · Aggregate functions

json_group_array()

Collects group values into a JSON array. SQLite and PostgreSQL.

sqlRunnable example sql course

Syntax

json_group_array(expression)

Example

Open in the lab

WITH lessons(title) AS (VALUES ('HTML'), ('CSS'))
SELECT json_group_array(title) AS titles FROM lessons;

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