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.



You May Interest

What is the XML Datatype in SQL Server ?

Using MS SQL DISTINCT

Changing Column Name of MS SQL Table with Query

What is the Bookmark Lookup and RID Lookup in SQL Server ?

MS SQL Getting a Random Row in a Table