RANK OVER

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, players are ranked by their score within each game level. Players with equal scores receive the same rank, and the next rank is skipped.

SELECT
    nickname,
    level,
    current_score,
    RANK() OVER (PARTITION BY level ORDER BY current_score DESC) AS rank_in_game
FROM
    (VALUES
        ('kennethpark', 9, 76),
        ('burchdenise', 9, 89),
        ('ymatthews', 9, 75),
        ('sabrina21', 9, 89)
    ) AS t(nickname, level, current_score)
ORDER BY level, nickname;

nickname text	level int	current_score int	rank_in_game long
burchdenise	9	89	1
kennethpark	9	76	3
sabrina21	9	89	1
ymatthews	9	75	4

Rows: 4Execution time: 2.79ms

PERCENT_RANK OVER

ROW_NUMBER OVER

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Type

Example

​Syntax

​Parameters

​Return Type

​Example

Syntax

Parameters

Return Type

Example