Search notes:
SQL: ROW_NUMBER, RANK and DENSE_RANK
row_number()
No duplicates, no gaps
rank()
Duplicates with gap possible
dense_rank()
Duplicates possible, no gaps
See also
Oracle SQL: ROW_NUMBER, RANK and DENSE_RANK
Ranking analytic functions
Index