Example: PERCENT_RANK and CUM_DIST - Teradata Vantage

The following SQL statement shows 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;