Computes the rank of an ordered set of value within groups. Tie values are assigned the same rank, and the next ranking is incremented by 1.

window value:DENSERANK() order:Times group:Racer

Output: Generates the new column, which contains the ranking of Times values, grouped by the Racer column.

window value:DENSERANK() order: order_col group: group_col

For more information on the order and group parameters, see Window Transform.

Example - Rank Functions