Aggregate

JSON_ARRAYAGG

MySQL

Mengumpulkan nilai-nilai dari beberapa baris menjadi JSON array. Berguna untuk menghasilkan output JSON dari query agregasi.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_ARRAYAGG(expr)

expranywajib

Ekspresi yang akan dikumpulkan ke dalam array

SQL

1 SELECT department,
2        JSON_ARRAYAGG(employee_id) AS employee_ids
3 FROM employees
4 GROUP BY department;

Mengumpulkan semua ID karyawan per departemen.

Hasil

Sales: [1, 5, 8, 12]

SQL

1 SELECT JSON_ARRAYAGG(product_name) AS products
2 FROM products
3 WHERE category = 'Electronics';

Membuat array JSON dari nama produk elektronik.

Hasil

products: ["iPhone", "Samsung Galaxy", "Sony TV"]

SQL

1 SELECT JSON_ARRAYAGG(name) AS sorted_names
2 FROM (
3   SELECT name FROM employees
4   ORDER BY name
5 ) AS sorted;

Membuat array dengan urutan tertentu.

Hasil

sorted_names: ["Alice", "Bob", "Charlie"]

JSON_AGG

PostgreSQL

ARRAY_AGG

Snowflake

JSON_GROUP_ARRAY

DuckDB

1	SELECT department,
2	JSON_ARRAYAGG(employee_id) AS employee_ids
3	FROM employees
4	GROUP BY department;

1	SELECT JSON_ARRAYAGG(product_name) AS products
2	FROM products
3	WHERE category = 'Electronics';

1	SELECT JSON_ARRAYAGG(name) AS sorted_names
2	FROM (
3	SELECT name FROM employees
4	ORDER BY name
5	) AS sorted;