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 the number of tie values. |
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 group
and order
parameters to define the groups of records and the ordering column to which this function is applied.
rank() |
Output: Generates the new column, which contains the ranking of mySales
, grouped by the Salesman
column.
rank() order: order_col group: group_col |
For more information on the order
and group
parameters, see Window Transform.