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.
Rank values start at
1 and increment.
Ranking order varies depending on the data type of the source data. For more information, see Sort Order.
You must use the
order parameters to define the groups of records and the order of those records to which this transform is applied.
window value:DENSERANK() order:Times group:Racer
Output: Generates the new column, which contains the ranking of
Times values, grouped by the
window value:DENSERANK() order: order_col group: group_col
For more information on the
group parameters, see Window Transform.