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

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;