PERCENT_RANK is similar to the CUME_DIST (cumulative distribution) function. The range of values returned by PERCENT_RANK is 0 to 1, inclusive. The first row in any set has a PERCENT_RANK of 0. The return value is NUMBER.
Nov 05, 2013 · Percentile ranks are calculated from 0 to 99.99 with lower ‘expression’ values having the lower pRank values, unless the optional INVERTED keyword is included. This optional keyword reverses the order such that the lower ‘expression’ values have the higher pRank values.