GROUP BY Clause Enhancements

SQL Server 2008 introduces a number of enhancements and changes to the grouping aggregate relational result set. These changes include the following:

ROLLUP and CUBE operator syntax changes

New GROUPING SETS operator

New GROUPING_ID() function

Get Microsoft® SQL Server 2008 R2 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.