Tag Archives: GROUPING SETS

GROUPING SETS – SQL Server 2008 (Video Tutorial)

You can use the GROUPING SETS extension of the GROUP BY clause to specify multiple groupings of data in one query. It generates the same result set that you would obtain by using the UNION ALL clause, but in a more efficient way. You can use GROUPING SETS to simplify complex aggregation queries into one [...]