Table 137. Rank Function
Field | Description |
|---|---|
Description | Returns the rank (1…n) of all the rows in the group by the value of sort_expression_list, with the same sort_expression values receiving the same rank. |
Syntax: | Rank(sort_expression_list) |
sort_expression_list | List of expressions (with optional sort direction specifications) separated by commas. That is, it specifies the column references used to sort the values. The default sort direction is ascending (ASC). |