Q:

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

mhmadesk

Save to bookmark

|

2022-07-19

|

404

Medium

0

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

To find the groups forming the subtotal in a row
To create group-wise grand totals for the groups specified within a GROUP BY clause
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
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

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-19

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)