Returns the relative rank of rows for a value_expression.
ANSI SQL:2011 window function.
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 …|
|1.0||highest in the result.|