Window

RANK

BigQuery

Assigns a rank to each row. Rows with equal values receive the same rank, and there is a gap after ties.

Tipe hasil: INT64Diperbarui: 13 Jun 2026

Syntax

SQL

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

Parameter

ORDER BYexpressionwajib

Determines the ranking order

PARTITION BYexpressionopsional

Divides data into groups (optional)

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`;

Rank contestants by score, with a gap after tied values.

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`;

Rank salespeople by total sales within each region.

Pertanyaan Umum tentang RANK

Apa itu fungsi RANK di BigQuery?

Assigns a rank to each row. Rows with equal values receive the same rank, and there is a gap after ties. Di BigQuery, fungsi RANK termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan RANK di BigQuery?

Gunakan sintaks berikut: RANK() OVER ([PARTITION BY partition_expression] ORDER BY sort_expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi RANK?

Fungsi RANK mengembalikan nilai bertipe INT64. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Apa saja parameter fungsi RANK?

Fungsi ini memiliki 1 parameter wajib dan 1 parameter opsional. Parameter yang digunakan: PARTITION BY (expression, opsional): Divides data into groups (optional); ORDER BY (expression, wajib): Determines the ranking order.

Fungsi Terkait

ROW_NUMBERDENSE_RANKPERCENT_RANKCUME_DISTNTILE

Ngulik Langsung

Sudah paham RANK? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

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`;