Aggregate

AVG

DuckDB

Menghitung nilai rata-rata (average) dari nilai numerik dalam sebuah kolom. Mengabaikan nilai NULL dalam perhitungan.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

AVG(expression) | AVG(DISTINCT expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik yang akan dihitung rata-ratanya

DISTINCTmodifieropsional

Menghitung rata-rata hanya dari nilai unik

Contoh Penggunaan

Rata-rata Harga Produk

SQL

1 SELECT AVG(price) as avg_price
2 FROM products;

Menghitung rata-rata harga semua produk.

Hasil

125000.50

Rata-rata dengan Pembulatan

SQL

1 SELECT
2   category,
3   ROUND(AVG(rating), 2) as avg_rating,
4   COUNT(*) as total_reviews
5 FROM reviews
6 GROUP BY category;

Menghitung rata-rata rating per kategori, dibulatkan 2 decimal.

Hasil

category	avg_rating	total_reviews
Electronics	4.25	1523
Books	4.52	892
Clothing	3.98	2341

AVG dengan FILTER untuk Perbandingan

SQL

1 SELECT
2   AVG(salary) as overall_avg,
3   AVG(salary) FILTER (WHERE department = 'Engineering') as eng_avg,
4   AVG(salary) FILTER (WHERE department = 'Marketing') as mkt_avg
5 FROM employees;

Membandingkan rata-rata gaji antar department dalam satu query.

Hasil

overall_avg	eng_avg	mkt_avg
8500000	12000000	7500000

Fungsi Terkait

COUNTSUMMINMAX

Kembali ke DuckDB Functions

1	SELECT
2	category,
3	ROUND(AVG(rating), 2) as avg_rating,
4	COUNT(*) as total_reviews
5	FROM reviews
6	GROUP BY category;

1	SELECT
2	AVG(salary) as overall_avg,
3	AVG(salary) FILTER (WHERE department = 'Engineering') as eng_avg,
4	AVG(salary) FILTER (WHERE department = 'Marketing') as mkt_avg
5	FROM employees;