26 April 2012

Difference Between CUBE and ROLLUP

* CUBE
generates a result set that shows aggregates for all combinations of values in the selected columns.



* ROLLUP
generates a result set that shows aggregates for a hierarchy of values in the selected columns.