Aggregation & Grouping in Oracle SQL

Aggregation is used to compute summary values like totals, averages, and counts. Grouping allows these aggregates to be calculated across subsets of data.

  • GROUP BY and HAVING
  • Aggregate Functions
  • ROLLUP and CUBE
  • GROUPING Functions