Murach's SQL Server 2005 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 150
How to code aggregate functions 150
Queries that use aggregate functions 152
How to group and summarize data 154
How to code the GROUP BY and HAVING clauses 154
Queries that use the GROUP BY and HAVING clauses 156
How the HAVING clause compares to the WHERE clause 158
How to code complex search conditions 160
How to summarize data using SQL Server extensions 162
How to use the ROLLUP operator 162
How to use the CUBE operator 164
Perspective 166
t


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

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



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.