The following SQL statement illustrates the difference between PERCENT_RANK and cumulative distribution.
SELECT sales_amt, PERCENT_RANK() OVER (ORDER BY sales_amt), CUME_DIST() OVER (ORDER BY sales_amt) FROM xsales;
sales_amt | PERCENT_Rank | CUME_DIST |
---|---|---|
100. | .000000 | 0.125000 |
120. | .142857 | 0.250000 |
130 | .285714 | .375000 |
140. | .428571 | .500000 |
147. | .571429 | .625000 |
150. | .714286 | .750000 |
155. | .857143 | .875000 |
160. | 1.000000 | 1.000000 |