What is the purpose of the SQL ROLLUP clause in a GROUP BY statement?

A. To sort the result set in ascending order

B. To filter rows based on a condition

C. To include subtotals and grand totals in the result set

D. To perform a join operation between tables

Correct Answer is :

C. To include subtotals and grand totals in the result set