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

ParameterDescriptionSupported 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_namegrade_leveltest_scorerank_in_class
kennethpark9766
burchdenise12895
ymatthews11753
sabrina2110783