Aggregate

PERCENTILE_CONT

PostgreSQL

Menghitung percentile kontinyu dari data. Menginterpolasi nilai jika percentile jatuh di antara dua nilai. Berguna untuk analisis statistik seperti median (percentile 0.5).

Tipe hasil: double precision

Syntax

SQL

PERCENTILE_CONT(fraction) WITHIN GROUP (ORDER BY expression)

Parameter

fractionnumericwajib

Nilai percentile antara 0 dan 1 (misal 0.5 untuk median)

expressionnumericwajib

Kolom yang akan dihitung percentilenya

Contoh Penggunaan

Menghitung Median

SQL

1 SELECT 
2   PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary) AS median_salary
3 FROM employees;

Menghitung median gaji (percentile ke-50).

Hasil

median_salary
8500000

Berbagai Percentile

SQL

1 SELECT 
2   PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY price) AS q1,
3   PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median,
4   PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY price) AS q3
5 FROM products;

Menghitung Q1, median, dan Q3 untuk analisis box plot.

Hasil

q1	median	q3
25000.0	50000.0	75000.0

Median per Kategori

SQL

1 SELECT 
2   category,
3   PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median_price
4 FROM products
5 GROUP BY category;

Menghitung median harga per kategori produk.

Fungsi Equivalen di Database Lain

PERCENTILE_CONT

Snowflake

PERCENTILE_CONT

BigQuery

Fungsi Terkait

STDDEVVARIANCECORRCOVAR_POPCOVAR_SAMPPERCENTILE_DISCMODE

Kembali ke PostgreSQL Functions

1	SELECT
2	PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary) AS median_salary
3	FROM employees;

1	SELECT
2	PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY price) AS q1,
3	PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median,
4	PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY price) AS q3
5	FROM products;

1	SELECT
2	category,
3	PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median_price
4	FROM products
5	GROUP BY category;