17.10 - Example: PERCENT_RANK and CUM_DIST - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

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