how to use the SQL Server GROUPING SETS to generate multiple grouping sets.
Shathana. S.R. Answered question
The following are the syntax that illustrates the GROUPING SET in SQL Server:
SELECT column_list, aggregate(column_name)
FROM table_name.
GROUP BY.
GROUPING SETS
(column1, column2),
(column1),
(column2),
()
Shathana. S.R. Answered question