SQL · JSON functions

json_agg()

Aggregates rows into a JSON array. PostgreSQL; SQLite uses json_group_array().

sqlRunnable example sql course

Syntax

json_agg(expression)

Example

Open in the lab

SELECT json_group_array(course) AS courses FROM (SELECT 'CSS' AS course UNION ALL SELECT 'HTML');

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