ROLLUP operator and CUBE operator in SQL Server

Question

I want to know what is difference between ROLLUP operator and CUBE operator in SQL Server. Thank you.

Akkiraju Ivaturi · 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 More info can be had from the following link: http://www.sqlhub.com/2009/05/use-of-cube-and-rollup-difference-of.html

Vulpes · Answer

Check out the MSDN docs for an explanation of the difference between these two operators: http://msdn.microsoft.com/en-us/library/ms189305(SQL.90).aspx