ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

When I first ran into ROLLUP and CUBE in SQL, I genuinely thought I understood them. I didn’t. I...