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

MS SQL Getting List of All Column Names of a Table

Adding Columns to a Table with a Query in MS SQL

Disadvantages of Using Stored Procedures in MS SQL

Which TCP/IP Port Does the SQL Server Run On ?

Finding List of Tables Using View in MS SQL