In simple terms the ROLLUP clause is used to get the subtotal and grand total in a set of fetched records based on groups. In other words we can say that ROLLUP clause extends the functionality of the GROUP BY Clause by returning rows containing a subtotal for each group along with a grand total […]