O'Reilly logo

Beginning SQL Queries: From Novice to Professional, Second Edition by Clare Churcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Clare Churcher 2016

Clare Churcher, Beginning SQL Queries, 10.1007/978-1-4842-1955-3_8

8. Aggregate Operations

Clare Churcher

(1)Studio B Productions, Great Neck, New York, USA

SQL has a number of functions for counting, summing, averaging, and otherwise performing aggregate operations on a table. These functions enable us to perform a variety of queries. For example, we can count the number of members in the club or find the average handicap. We can group the data in different ways to find aggregates. For example, we might want to count the number of tournament entries in each individual year, or we might want to find the number of entries in each particular tournament.

In this chapter we will look at simple aggregates and how to make the most ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required