16.20 - Example: PERCENT_RANK and CUM_DIST - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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