Introduction
Ranking functions
Selecting n-th row
Summary

## Instruction

Perfect!

As we said, RANK() will always leave gaps in numbering when more than one row share has the same value. You can change this behavior by using DENSE_RANK():

SELECT
Name,
Platform,
EditorRating,
DENSE_RANK() OVER(ORDER BY EditorRating ASC) AS Ranking
FROM Game;


DENSE_RANK() gives a "dense" rank indeed – there are no gaps in the numbering.

## Exercise

Click to run the modified example.

We've now got three rows with rank 1, followed by a fourth row with rank 2. That's the difference between RANK() and DENSE_RANK() – the latter never leaves gaps.