User's Guide

Part II. Tutorials

About this chapter

This chapter describes how to construct queries that tell you aggregate information. Examples of aggregate information are:

• The total of all values in a column
• The number of distinct entries in a column
• The average value of entries in a column

A first look at aggregate functions

Using aggregate functions to obtain grouped data

Restricting groups