JSON

JSON_GROUP_ARRAY

DuckDB

Fungsi aggregate yang mengumpulkan nilai dari multiple rows menjadi JSON array. Mirip dengan ARRAY_AGG tapi menghasilkan format JSON.

Tipe hasil: JSON

Syntax

SQL

JSON_GROUP_ARRAY(expression)

expressionANYwajib

Nilai yang akan dikumpulkan ke dalam JSON array

SQL

1 SELECT
2   department,
3   JSON_GROUP_ARRAY(name) as employees_json
4 FROM employees
5 GROUP BY department;

Mengumpulkan nama karyawan per departemen sebagai JSON array.

Hasil

department	employees_json
Sales	["Alice", "Bob"]
Tech	["Carol", "David"]

SQL

1 SELECT
2   category,
3   JSON_GROUP_ARRAY(JSON_OBJECT('id', id, 'name', name)) as products_json
4 FROM products
5 GROUP BY category;

Membuat JSON array berisi objects untuk setiap kategori.

Hasil

category	products_json
Books	[{"id":1,"name":"SQL Guide"},{"id":2,"name":"Data Book"}]

JSON_AGG

PostgreSQL

JSON_ARRAYAGG

MySQL

ARRAY_AGG

Snowflake

1	SELECT
2	department,
3	JSON_GROUP_ARRAY(name) as employees_json
4	FROM employees
5	GROUP BY department;

1	SELECT
2	category,
3	JSON_GROUP_ARRAY(JSON_OBJECT('id', id, 'name', name)) as products_json
4	FROM products
5	GROUP BY category;