In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

Question

Admin · Accepted Answer

to create a grouping for expressions or columns speciﬁed within a group by clause in one direction, from right to left for calculating the subtotals

Admin · Answer

to ﬁnd the groups forming the subtotal in a row

Admin · Answer

to create group-wise grand totals for the groups speciﬁed within a group by clause

Admin · Answer

to create a grouping for expressions or columns speciﬁed within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals

Q. In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

Discusssion