The dense_rank() window function returns the number distinct values of the order by clause that are sorted before the current row +1.
SELECT DENSE_RANK() OVER (ORDER BY …)
FROM …Related
Similar functions:
row_number(),rank(),percent_rank(),cume_dist().
Normative References
The rank() window function is defined in ISO/IEC 9075:2016-2 as part of optional feature T611, “Elementary OLAP operations”.
