Aggregate

MEDIAN

Snowflake

Menghitung nilai median (nilai tengah) dari sebuah kolom numerik. Median adalah nilai yang membagi dataset menjadi dua bagian sama besar.

Tipe hasil: FLOATDiperbarui: 6 Jan 2026

Syntax

SQL

MEDIAN(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik yang akan dihitung mediannya

Contoh Penggunaan

Median Gaji Karyawan

SQL

1 SELECT MEDIAN(salary) as median_salary
2 FROM employees;

Menghitung gaji median dari semua karyawan.

Hasil

75000.00

Perbandingan MEDIAN vs AVG

SQL

1 SELECT
2   department,
3   MEDIAN(salary) as median_salary,
4   AVG(salary) as avg_salary,
5   AVG(salary) - MEDIAN(salary) as difference
6 FROM employees
7 GROUP BY department;

Membandingkan median dan rata-rata gaji per department. Perbedaan besar menunjukkan adanya outliers.

Hasil

DEPARTMENT	MEDIAN_SALARY	AVG_SALARY	DIFFERENCE
Engineering	120000	135000	15000
Sales	65000	72000	7000

Median Harga per Kategori

SQL

1 SELECT
2   category,
3   MEDIAN(price) as median_price,
4   MIN(price) as min_price,
5   MAX(price) as max_price
6 FROM products
7 GROUP BY category
8 ORDER BY median_price DESC;

Menganalisis distribusi harga per kategori menggunakan median.

Hasil

CATEGORY	MEDIAN_PRICE	MIN_PRICE	MAX_PRICE
Electronics	500000	50000	5000000
Furniture	250000	100000	1500000

Fungsi Equivalen di Database Lain

MEDIAN

DuckDB

Fungsi Terkait

STDDEVSTDDEV_POPSTDDEV_SAMPVARIANCEVAR_POPVAR_SAMPCORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISCMODE

Kembali ke Snowflake Functions

1	SELECT
2	department,
3	MEDIAN(salary) as median_salary,
4	AVG(salary) as avg_salary,
5	AVG(salary) - MEDIAN(salary) as difference
6	FROM employees
7	GROUP BY department;

1	SELECT
2	category,
3	MEDIAN(price) as median_price,
4	MIN(price) as min_price,
5	MAX(price) as max_price
6	FROM products
7	GROUP BY category
8	ORDER BY median_price DESC;