Example: Rank and Relative Rank - Analytics Database - Teradata Vantage

Determine the rank and the relative rank of Christmas sales.

   SELECT sales_amt,
   RANK() OVER (ORDER BY sales_amt),
   PERCENT_RANK () OVER (ORDER BY sales_amt)
   FROM xsales;