Window

PERCENT_RANK

MySQL

Menghitung ranking relatif sebagai persentase (0 sampai 1). Baris pertama selalu 0, baris terakhir mendekati 1.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

PERCENT_RANK() OVER ([PARTITION BY col] ORDER BY col)

ORDER BYcolumn(s)wajib

Kolom untuk menentukan urutan ranking

PARTITION BYcolumn(s)opsional

Kolom untuk membagi data menjadi grup (opsional)

SQL

1 SELECT name, salary,
2   PERCENT_RANK() OVER (ORDER BY salary) AS percentile
3 FROM employees;

Posisi relatif gaji dalam distribusi.

Hasil

(salary percentile for each employee)

SQL

1 SELECT salesperson, total_sales,
2   ROUND(PERCENT_RANK() OVER (ORDER BY total_sales) * 100, 1) AS percentile
3 FROM sales;

Performa sales sebagai persentase.

Hasil

(sales performance percentile)

SQL

1 SELECT dept, name, salary,
2   PERCENT_RANK() OVER (
3     PARTITION BY dept 
4     ORDER BY salary
5   ) AS dept_percentile
6 FROM employees;

Persentil gaji dalam departemen.

Hasil

(salary percentile within department)

1	SELECT name, salary,
2	PERCENT_RANK() OVER (ORDER BY salary) AS percentile
3	FROM employees;

1	SELECT salesperson, total_sales,
2	ROUND(PERCENT_RANK() OVER (ORDER BY total_sales) * 100, 1) AS percentile
3	FROM sales;