SQL Server Architecture Question: Download MS SQL Server Architecture PDF
What is the difference between CUBE operator and ROLLUP 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.
ROLLUP generates a result set that represents aggregates for a hierarchy of values in the selected columns.
| Previous Question | Next Question |
| Please illustrate physical database architecture? | Do you know what are the restrictions applicable while creating views? |