Example: Sorting and Reporting Items by Category and Descending Revenue Rank Using RANK (Teradata) - Teradata VantageCloud Lake

Sort items by category and report items in order of descending revenue rank.

   SELECT Category, Item, Revenue, RANK(Revenue) AS ItemRank
   FROM ItemCategory,
      (SELECT Item, SUM(sales) AS Revenue
      FROM DailySales
      GROUP BY Item) AS ItemSales
   WHERE ItemCategory.Item = ItemSales.Item
   ORDER BY Category, ItemRank DESC;

The result may look like the following table.