17.00 - 17.05 - 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.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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