Window

DENSE_RANK

MySQL

Memberikan ranking tanpa gap untuk nilai yang sama. Ranking berurutan tanpa melewati nomor.

Tipe hasil: BIGINTDiperbarui: 7 Jan 2026

Syntax

SQL

DENSE_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, score,
2   DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank
3 FROM students;

Ranking padat tanpa melewati nomor.

Hasil

Jika 2 siswa skor 90, berikutnya rank 2

SQL

1 SELECT name, score,
2   RANK() OVER (ORDER BY score DESC) AS rank,
3   DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank
4 FROM students;

Melihat perbedaan RANK vs DENSE_RANK.

Hasil

(comparison of both ranking methods)

SQL

1 SELECT product, price,
2   DENSE_RANK() OVER (ORDER BY price DESC) AS price_tier
3 FROM products;

Mengelompokkan produk berdasarkan tier harga.

Hasil

(products grouped by price tier)

1	SELECT name, score,
2	DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank
3	FROM students;

1	SELECT name, score,
2	RANK() OVER (ORDER BY score DESC) AS rank,
3	DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank
4	FROM students;

1	SELECT product, price,
2	DENSE_RANK() OVER (ORDER BY price DESC) AS price_tier
3	FROM products;