Aggregate

JSON_OBJECTAGG

MySQL

Membuat JSON object dari pasangan key-value hasil agregasi. Berguna untuk mentransformasi data tabular menjadi struktur JSON object.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_OBJECTAGG(key, value)

Parameter

keystringwajib

Ekspresi untuk key object (harus string)

valueanywajib

Ekspresi untuk value object

Contoh Penggunaan

Membuat Object dari Key-Value

SQL

1 SELECT JSON_OBJECTAGG(setting_key, setting_value) AS settings
2 FROM user_settings
3 WHERE user_id = 1;

Mengubah baris pengaturan menjadi JSON object.

Hasil

settings: {"theme": "dark", "language": "id"}

Pivot Data ke JSON

SQL

1 SELECT user_id,
2        JSON_OBJECTAGG(product_name, quantity) AS purchases
3 FROM orders
4 GROUP BY user_id;

Membuat object pembelian per user.

Hasil

user_id: 1, purchases: {"iPhone": 1, "Charger": 2}

Dengan Agregasi Nilai

SQL

1 SELECT JSON_OBJECTAGG(category, total_sales) AS sales_by_category
2 FROM (
3   SELECT category, SUM(amount) AS total_sales
4   FROM orders
5   GROUP BY category
6 ) AS summary;

Membuat object ringkasan penjualan per kategori.

Hasil

sales_by_category: {"Electronics": 50000, "Clothing": 25000}

Fungsi Equivalen di Database Lain

JSON_OBJECT_AGG

PostgreSQL

OBJECT_AGG

Snowflake

Fungsi Terkait

JSON_ARRAYAGG

Kembali ke MySQL Functions

1	SELECT JSON_OBJECTAGG(setting_key, setting_value) AS settings
2	FROM user_settings
3	WHERE user_id = 1;

1	SELECT user_id,
2	JSON_OBJECTAGG(product_name, quantity) AS purchases
3	FROM orders
4	GROUP BY user_id;

1	SELECT JSON_OBJECTAGG(category, total_sales) AS sales_by_category
2	FROM (
3	SELECT category, SUM(amount) AS total_sales
4	FROM orders
5	GROUP BY category
6	) AS summary;