What is a ROLLUP Clause in SQL Server ?
ROLLUP clause is used to do aggregate operation on multiple levels in a hierarchy. If we want to sum on different levels without adding any new column, then we can do it easily using ROLLUP. We have to just add the WITH ROLLUP Clause in the group by clause.