Did you know? SQL Server 2008 includes GROUPING SETS
Video Title :
Did you know? SQL Server 2008 includes GROUPING SETS
Description :
SQL Server 2008 includes GROUPING SETS:
Grouping Sets is an extension to the GROUP BY clause that lets users define multiple groupings in the same query. Grouping Sets produces a single result set that is equivalent to a UNION ALL of differently grouped rows, making aggregation querying and reporting easier and faster.