{"id":1378,"date":"2018-01-20T01:46:42","date_gmt":"2018-01-20T08:46:42","guid":{"rendered":"https:\/\/sqltutorial.org\/?page_id=1378"},"modified":"2025-02-14T07:41:14","modified_gmt":"2025-02-14T14:41:14","slug":"sql-rollup","status":"publish","type":"page","link":"https:\/\/www.sqltutorial.org\/sql-rollup\/","title":{"rendered":"SQL ROLLUP"},"content":{"rendered":"\n

Summary<\/strong>: In this tutorial, you’ll learn how to use the SQL ROLLUP<\/code> to return aggregated results at multiple levels of detail.<\/p>\n\n\n\n

Introduction to the SQL ROLLUP #<\/a><\/h2>\n\n\n\n

The GROUP BY<\/a><\/code> clause allows you to group rows into groups by values in one or more columns. Typically, you use an aggregate function to return the aggregated result for each group.<\/p>\n\n\n\n

However, the GROUP BY<\/code> clause within an aggregate function<\/a> can only return an aggregate result at a single level of detail.<\/p>\n\n\n\n

To return aggregated results at multiple levels of details, you use the ROLLUP<\/code> with the GROUP BY<\/code> clause:<\/p>\n\n\n

SELECT<\/span>\n  column1,\n  column2,\n  aggregate_function (column3)\nFROM<\/span>\n  table_name\nGROUP<\/span> BY<\/span>\n  ROLLUP<\/span> (column1, column2);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, you place the columns you want to group within parentheses after the ROLLUP<\/code> keyword.<\/p>\n\n\n\n
The ROLLUP<\/code> assumes that there is a hierarchy between column1<\/code> and column2<\/code>:<\/p>\n\n\n
column1 > column2<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Therefore, the ROLLUP<\/code> helps generate reports that include subtotals and totals.<\/p>\n\n\n\n
How the ROLLUP<\/code> works<\/p>\n\n\n\n