Ranking#
Ranking functions return a ranking value for each row within a partition of a result set — a sequential number, rank, dense rank or tile.
Function |
Description |
|---|---|
Returns the rank of rows within the partition of a result set, without any gaps in the ranking. The rank of a row is one plus the number of distinct ranks that come before the row in question. |
|
Distributes the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at one. For each row, NTILE returns the number of the group to which the row belongs. |
|
Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question. |
|
Numbers the output of a result set. More specifically, returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. |