Aggregate

SUM

BigQuery

Menghitung total penjumlahan dari nilai numerik dalam sebuah kolom. Mendukung berbagai tipe numerik dan sangat efisien untuk analisis data besar di BigQuery.

Tipe hasil: Sama dengan tipe input (INT64, FLOAT64, NUMERIC, atau BIGNUMERIC)Diperbarui: 7 Jan 2026

Syntax

SQL

SUM(expression) | SUM(DISTINCT expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik yang akan dijumlahkan (INT64, FLOAT64, NUMERIC, BIGNUMERIC)

DISTINCTmodifieropsional

Menjumlahkan hanya nilai unik

Contoh Penggunaan

Menjumlahkan Total Penjualan

SQL

1 SELECT SUM(amount) as total_revenue
2 FROM `project.dataset.transactions`
3 WHERE DATE(transaction_date) = '2024-01-15';

Menghitung total revenue untuk tanggal tertentu.

Hasil

125750000.00

SUM dengan GROUP BY

SQL

1 SELECT
2   product_category,
3   SUM(quantity) as total_sold,
4   SUM(amount) as total_revenue
5 FROM `project.dataset.sales`
6 GROUP BY product_category
7 ORDER BY total_revenue DESC;

Menghitung total quantity dan revenue per kategori produk.

Hasil

product_category	total_sold	total_revenue
Electronics	52300	87500000.00
Fashion	125000	31250000.00
Food & Beverage	89200	6250000.00

SUM dengan Conditional

SQL

1 SELECT
2   SUM(amount) as total_sales,
3   SUM(IF(payment_method = 'credit_card', amount, 0)) as credit_card_sales,
4   SUM(IF(payment_method = 'bank_transfer', amount, 0)) as transfer_sales
5 FROM `project.dataset.transactions`;

Menghitung total dan breakdown per payment method dalam satu query.

Hasil

total_sales	credit_card_sales	transfer_sales
125000000.00	85000000.00	32500000.00

Running Total dengan Window Function

SQL

1 SELECT
2   order_date,
3   amount,
4   SUM(amount) OVER (ORDER BY order_date) as running_total
5 FROM `project.dataset.daily_sales`
6 ORDER BY order_date;

Menghitung running total (kumulatif) dari penjualan harian.

Hasil

order_date	amount	running_total
2024-01-01	1500000	1500000
2024-01-02	2300000	3800000
2024-01-03	1800000	5600000

Fungsi Terkait

COUNTAVGMINMAX

Kembali ke BigQuery Functions

1	SELECT SUM(amount) as total_revenue
2	FROM `project.dataset.transactions`
3	WHERE DATE(transaction_date) = '2024-01-15';

1	SELECT
2	product_category,
3	SUM(quantity) as total_sold,
4	SUM(amount) as total_revenue
5	FROM `project.dataset.sales`
6	GROUP BY product_category
7	ORDER BY total_revenue DESC;

1	SELECT
2	SUM(amount) as total_sales,
3	SUM(IF(payment_method = 'credit_card', amount, 0)) as credit_card_sales,
4	SUM(IF(payment_method = 'bank_transfer', amount, 0)) as transfer_sales
5	FROM `project.dataset.transactions`;

1	SELECT
2	order_date,
3	amount,
4	SUM(amount) OVER (ORDER BY order_date) as running_total
5	FROM `project.dataset.daily_sales`
6	ORDER BY order_date;