Returns the relative rank of rows for a value_expression.
Type
ANSI SQL:2011 window function.
Computation
The assigned rank of a row is defined as 1 (one) plus the number of rows that precede the row and are not peers of it.
PERCENT_RANK is expressed as an approximate numeric ratio between 0.0 and 1.0.
| PERCENT_RANK has this value … | FOR the result row assigned this rank … |
|---|---|
| 0.0 | 1. |
| 1.0 | highest in the result. |