View Source

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.
This function works with the following transforms:
This function assigns ranking values to match the total number of rows in a group. For fewer discrete ranking values when ties are present, see DENSERANK Function.

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.

Example - Rank Functions