CUME_DIST
Examples
select
id,
salary,
cume_dist() over (order by salary)
from employee
order by salary;
Result
id salary cume_dist -- ------ --------- 3 8.00 0.2 4 9.00 0.4 1 10.00 0.8 5 10.00 0.8 2 12.00 1
CUME_DIST
Examplesselect
id,
salary,
cume_dist() over (order by salary)
from employee
order by salary;
id salary cume_dist -- ------ --------- 3 8.00 0.2 4 9.00 0.4 1 10.00 0.8 5 10.00 0.8 2 12.00 1
DENSE_RANK()
Rank of rows in a partition without gaps
BIGINT
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.