I want to know what is difference between ROLLUP operator and CUBE operator in SQL Server.
Thank you.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Akkiraju IvaturiPosted Aug 6, 2012, 7:37 PM
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
VulpesPosted Aug 6, 2012, 6:21 AM
http://msdn.microsoft.com/en-us/library/ms189305(SQL.90).aspx