Group by GROUPING SETS for custom rollups in Oracle

(Bob Watkins) When you use GROUP BY with the summary functions like COUNT and SUM, you normally don’t get multi-level totals. Each unique combination of the columns in the GROUP BY generates a total, but these totals aren’t “rolled up” into higher level totals.

Read More - Register for Free Membership