RANK
Rank the current row within the requested window with gaps.
For more information on usage, please refer to Window Functions.
Syntax
RANK() OVER ([PARTITION BY <partition_by>] ORDER BY <order_by> [ASC|DESC] )
Parameters
| 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 |
Return Type
INTEGER
Example
In this example below, players are ranked based on their test scores for their game level.
SELECT
nickname,
level,
current_score,
RANK() OVER (PARTITION BY level ORDER BY current_score DESC ) AS rank_in_game
FROM
players;
Returns:
| first_name | grade_level | test_score | rank_in_class |
|---|---|---|---|
| kennethpark | 9 | 76 | 6 |
| burchdenise | 12 | 89 | 5 |
| ymatthews | 11 | 75 | 3 |
| sabrina21 | 10 | 78 | 3 |