SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Daily SQL Server 2008 New Feature – Day 24

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Wednesday 16th June 2010

Grouping Sets

Grouping Sets are an extension to the GROUP BY clause that lets you define multiple groupings in the same query.

It allows you to produce a single result set that is equivalent to a UNION ALL of differently grouped rows. This will make aggregation querying and reporting easier and faster.


No comments.

Leave a Comment

Please register or log in to leave a comment.