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