Can I use… dense_rank()

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.