Question

What are ROLLUP and CUBE in T-SQL?

Answer 1

ROLLUP and CUBE are the grouping sets used along with GROUP BY clause to generate summarized aggregations. These are mainly used for Data Audits and Report Generation.

Answer 2

Rollup and cube are the grouping sets used along with GROUP BY clause to generate summarized aggregations. These are mainly used for Data Audits and Report Generation.