RankDense

Description

RankDense returns the dense rank of the current row, without gaps after ties.

Syntax

RankDense(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

RankDense(SalesAmount)

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