SQL · Aggregate functions

array_agg()

Collects group values into an array. PostgreSQL only.

sqlRunnable example sql course

Syntax

array_agg(expression)

Example

Open in the lab

-- PostgreSQL
-- SELECT array_agg(title) FROM lessons;

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