GROUPING SETS « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. GROUPING SETS
1.GROUPING SETS: get the subtotal rows
2.Use GROUPING SETS and RANK() to get just the sales amount subtotal rankings