What Is The Difference Between Cube Operator And Roll Up Operator?

1.	What Is The Difference Between Cube Operator And Roll Up Operator?
Answer» CUBE GENERATES a RESULT set that REPRESENTS AGGREGATES for all combinations of values in the selected COLUMNS. ROLLUP generates a result set that represents aggregates for a hierarchy of values in the selected columns.

Answer»

CUBE GENERATES a RESULT set that REPRESENTS AGGREGATES for all combinations of values in the selected COLUMNS.
ROLLUP generates a result set that represents aggregates for a hierarchy of values in the selected columns.

Discussion