how to use the SQL Server GROUPING SETS to generate multiple grouping sets.
Shathana. S.R. Answered question May 27, 2023
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 May 27, 2023