T-SQL by Example

🚧 Grouping Sets

🚧 Coming soon: Subtotals and grand totals with GROUPING_ID().

-- Placeholder example
SELECT Region, ProductCategory, SUM(Amount) AS Sales
FROM dbo.Facts
GROUP BY GROUPING SETS ( (Region, ProductCategory), (Region), () );