GROUP BY Clause Enhancements
SQL Server 2008 introduced a number of enhancements and changes to the grouping aggregate relational result set, including the following:
GROUPING SETS
operator
GROUPING_ID()
function
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.