|SQL - Structured Query Language|
GROUP BY Clause
GROUP BY clause is used to selected set of rows into a set for summary rows by the values of one or more columns or expressions in SQL Server 2012. One row is returned for each group. Aggregate functions in the SELECT clause list provide information about each group instead of individual rows.
Query Output Screen
More Reference URL: http://technet.microsoft.com/en-us/library/ms177673.aspx
* * * * *