Using Grouping Sets in SQL Server 2008

Friday Oct 31st 2008 by DatabaseJournal.com Staff

A neat new feature in SQL Server 2008 is the GROUPING SETS clause, which allows you to easily specify combinations of field groupings in your queries to see different levels of aggregated data.

[From ZDNet Asia]

The GROUP BY clause is a SQL language construct used to priovide summary data for column returned in a SELECT statement. This functionality groups values from specified fields together, providing a single record of distinct values for each group.

The article continues at http://www.zdnetasia.com/techguide/storage/0,39045058,62047753,00.htm

Mobile Site | Full Site