Q. What does the ROLLUP operator do in SQL?

A
Filters data
B
Generates subtotals and a grand total
C
Sorts data
D
Joins tables
Solution:

ROLLUP, used with GROUP BY, generates subtotals and a grand total for grouped data.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!