DENSE_RANK()

`DENSE_RANK()`

Rank of rows in a partition without gaps

Result type

BIGINT

Syntax

DENSE_RANK () OVER <window_name_or_spec>

Rows with the same window_order values get the same rank within the partition window_partition, if specified.The dense rank of a row is equal to the number of different rank values in the partition preceding the current row, plus one.

`DENSE_RANK` Examples

select
  id,
  salary,
  dense_rank() over (order by salary)
from employee
order by salary;

Result

id salary dense_rank
-- ------ ----------
 3  8.00           1
 4  9.00           2
 1 10.00           3
 5 10.00           3
 2 12.00           4

DENSE_RANK()

DENSE_RANK()

DENSE_RANK Examples

`DENSE_RANK()`

`DENSE_RANK` Examples