Murach's Oracle SQL and PL/SQL
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 160
How to code aggregate functions 160
Queries that use aggregate functions 162
How to group and summarize data 164
How to code the GROUP BY and HAVING clauses 164
Queries that use the GROUP BY and HAVING clauses 166
How the HAVING clause compares to the WHERE clause 168
How to code complex search conditions 170
How to summarize data using Oracle extensions 172
How to use the ROLLUP operator 172
How to use the CUBE operator 174


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

Murach's Oracle SQL and PL/SQL

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.