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

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...

What is the Filtered Index in SQL Server ?

What is Service Broker in SQL Server ?

What are The Different Backup Options With SQL Server ?