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.

window value:RANK() order:MySales group:Salesman

Output: Generates the new column, which contains the ranking of mySales, grouped by the Salesman column.

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

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

Example - Rank Functions