Question: what is the difference between rollup and cube in sql server?
Answer: ROLLUP operator generates aggregated results for the selected columns in a hierarchical way. On the other hand, CUBE generates a aggregated result that contains all the possible combinations for the selected columns. Here data is aggregated in hierarchical manner.