Aggregate

MEDIAN

DuckDB

Menghitung nilai median (nilai tengah) dari sebuah kolom numerik. Lebih robust terhadap outlier dibanding AVG.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

MEDIAN(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik yang akan dihitung mediannya

Contoh Penggunaan

Median Gaji

SQL

1 SELECT
2   MEDIAN(salary) as median_salary,
3   AVG(salary) as avg_salary
4 FROM employees;

Membandingkan median dan rata-rata gaji. Median lebih akurat jika ada outlier.

Hasil

median_salary	avg_salary
8500000	12000000

Median per Kategori

SQL

1 SELECT
2   category,
3   MEDIAN(price) as median_price,
4   AVG(price) as avg_price,
5   COUNT(*) as total_products
6 FROM products
7 GROUP BY category;

Menghitung median harga per kategori produk.

Hasil

category	median_price	avg_price	total_products
Electronics	1500000	3500000	45
Clothing	250000	450000	120

Fungsi Terkait

STDDEVVARIANCEMODE

Kembali ke DuckDB Functions

1	SELECT
2	MEDIAN(salary) as median_salary,
3	AVG(salary) as avg_salary
4	FROM employees;

1	SELECT
2	category,
3	MEDIAN(price) as median_price,
4	AVG(price) as avg_price,
5	COUNT(*) as total_products
6	FROM products
7	GROUP BY category;