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()

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