The percent_rank() window function returns a relative measure (0-1) of where the current row is in the result according to the order by clause.
SELECT PERCENT_RANK() OVER (ORDER BY …)
FROM …Related
Similar functions:
row_number(),rank(),dense_rank(),cume_dist().
Normative References
The percent_rank() window function is defined in ISO/IEC 9075:2016-2 as part of optional feature T612, “Advanced OLAP operations”.
