Murach's SQL Server 2008 for Developers
How to code summary queries

This chapter teaches you how to code SQL queries that summarize data. These types of queries use aggregate functions that make it easy to handle operations like averaging or totaling data.
Chapter 5 How to code summary queries
How to work with aggregate functions 158
How to code aggregate functions 158
Queries that use aggregate functions 160
How to group and summarize data 162
How to code the GROUP BY and HAVING clauses 162
Queries that use the GROUP BY and HAVING clauses 164
How the HAVING clause compares to the WHERE clause 166
How to code complex search conditions 168
How to summarize data using SQL Server extensions 170
How to use the ROLLUP operator 170
How to use the CUBE operator 172
How to use the GROUPING SETS operator 174
 


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.