Data connectivity & integrationPipeline Builder ExpressionsDense rank

Dense rank

Supported in: Batch

Returns the rank of rows within a window partition, without any gaps. In case of ties the rows get same rank. The difference between rank and dense_rank is that dense_rank leaves no gaps in ranking sequence when there are ties.

Expression categories: Aggregate

Declared arguments

This function does not take any arguments.

Output type: Integer