Returns an ordered ranking of rows based on the value_expression in the ORDER BY clause.
The ranks are consecutive integers beginning with 1. Rows with equal values receive the same rank. Rank values are not skipped in the event of ties.
Type
ANSI SQL:2011 window function.