The GROUP BY clause’s subclause, SQL Server ROLLUP, offers a shortcut for defining multiple grouping sets.

In contrast to the CUBE subclause, ROLLUP only makes a subset of all grouping sets based on the dimension columns.

ROLLUP only generates grouping sets based on the hierarchy it assumes exists between the dimension columns when generating the grouping sets.

For reporting purposes, the ROLLUP is frequently used to produce subtotals and totals.