how to use the SQL Server ROLLUP to generate multiple grouping sets.
Shathana. S.R. Answered question
Similar to GROUPING SETS , you can use the ROLLUP option in a single query to generate multiple grouping sets. ROLLUP generates all grouping sets that make sense in this hierarchy.
Shathana. S.R. Answered question