SQL Server Architecture Question: Download Questions PDF
What is the difference between CUBE operator and ROLLUP operator?
![MS SQL Server Architecture Interview Answer MS SQL Server Architecture Interview Question](https://globalguideline.com/public/images/interview/33.png)
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.
Download MS SQL Server Architecture Interview Questions And Answers
PDF
Previous Question | Next Question |
Please illustrate physical database architecture? | Do you know what are the restrictions applicable while creating views? |