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