SQL Server Architecture Question:
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? |