Abstract
So far, you have learned to write simple queries that include filtering and ordering. You can also work with expressions built with operators and functions. The previous chapter taught you how to write queries with multiple tables so that the data makes sense in applications and reports. Now it is time to learn about a special type of query, aggregate queries, used to group and summarize data. You may find that writing aggregate queries is more challenging than the other queries you have learned so far, but by taking a step-by-step approach, you will realize that they are not difficult to write at all. Be sure to take the time to understand the examples and complete all the exercises before moving on to the next section.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Kathi Kellenberger
About this chapter
Cite this chapter
Kellenberger, K. (2009). Grouping and Summarizing Data. In: Beginning T-SQL 2008. Apress. https://doi.org/10.1007/978-1-4302-2462-4_5
Download citation
DOI: https://doi.org/10.1007/978-1-4302-2462-4_5
Publisher Name: Apress
Print ISBN: 978-1-4302-2461-7
Online ISBN: 978-1-4302-2462-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books