Reference material for DENSE_RANK function
Parameter | Description | Supported input types |
---|---|---|
<partition_by> | The expression used for the PARTITION BY clause. | Any |
<order_by> | The expression used in the ORDER BY clause. This parameter determines what value will be ranked. | Any |
nickname | level | highscore | game_rank |
---|---|---|---|
kennethpark | 9 | 76 | 6 |
sabrina21 | 10 | 78 | 3 |
rileyjon | 11 | 94 | 1 |
ymatthews | 12 | 92 | 4 |