Window

RANK

BigQuery

Memberikan peringkat untuk setiap baris. Baris dengan nilai sama mendapat peringkat sama, dan ada gap setelah ties.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

RANK() OVER ([PARTITION BY partition_expression] ORDER BY sort_expression)

Parameter

ORDER BYexpressionwajib

Menentukan urutan ranking

PARTITION BYexpressionopsional

Membagi data ke dalam grup (opsional)

Contoh Penggunaan

Competition Ranking

SQL

1 SELECT
2   name,
3   score,
4   RANK() OVER (ORDER BY score DESC) as rank
5 FROM `project.dataset.contestants`;

Ranking dengan gap setelah ties.

Hasil

name	score	rank
Alice	100	1
Bob	100	1
Charlie	90	3
David	80	4

Sales Ranking per Region

SQL

1 SELECT
2   salesperson,
3   region,
4   total_sales,
5   RANK() OVER (PARTITION BY region ORDER BY total_sales DESC) as region_rank
6 FROM `project.dataset.sales_summary`;

Ranking salesperson per region.

Fungsi Terkait

ROW_NUMBERDENSE_RANKPERCENT_RANKCUME_DISTNTILE

Kembali ke BigQuery Functions

1	SELECT
2	name,
3	score,
4	RANK() OVER (ORDER BY score DESC) as rank
5	FROM `project.dataset.contestants`;

1	SELECT
2	salesperson,
3	region,
4	total_sales,
5	RANK() OVER (PARTITION BY region ORDER BY total_sales DESC) as region_rank
6	FROM `project.dataset.sales_summary`;