WITH ROLLUP Modifier
WITH ROLLUP Modifier:
We can use this modifier with GROUP BY clause to get summary output.
Syntax:
SELECT [col_name1,col_name2,…] FROM [tab_name] GROUP BY [col_name] WITH ROLLUP;
Example:
SELECT doc_id,sum(total_count) FROM wordlist GROUP BY doc_id WITH ROLLUP;
Output
+——–+——————————-+
| docid | sum(total_count) |
+——–+——————————-+
| 12 | 123 |
| 15 | 3423 |
| NULL | 3546 |
+——–+————————–+
