Abstract
Grouping is primarily performed in SQL Server by using the GROUP BY clause in a SELECT query to determine in which groups rows should be put. Data is summarized by using the SUM function. The simplified syntax is as follows:
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2012 Jason Brimhall
About this chapter
Cite this chapter
Brimhall, J., Dye, D., Gennick, J., Roberts, A., Sheffield, W. (2012). Grouping and Summarizing. In: SQL Server 2012 T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4201-7_5
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4201-7_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4200-0
Online ISBN: 978-1-4302-4201-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books