Skip to content

Rank

Description

Rank returns the rank of the current row, leaving gaps after ties.

Syntax

Rank(value)

Parameters

Parameter Required Type Description
value Yes Field or expression Expression used for ranking.

Notes

Window functions operate over the current ordered window or query context.

Example

Rank(SalesAmount)

The expression returns the calculated result according to the current query context.