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? |