Q:

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

0

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


  1. To find the groups forming the subtotal in a row
  2. To create group-wise grand totals for the groups specified within a GROUP BY clause
  3. To create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals
  4. To create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

(c).To create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now