16 lines (9 loc) · 376 Bytes

SQL Server CUBE and ROLLUP

Please go over GROUPING SETS first.

SQL Server CUBE examples

SQL Server ROLLUP examples

Replace CUBE with ROLLUP above and run!