Previous Topic: ScenariosNext Topic: Aggregate Functions


Using Aggregate Functions

Goal

When you have completed this chapter, you will be able to use aggregate functions to count rows of data and to calculate averages, sums, maximums, and minimums for groups of data.

Summary

You can use the aggregate functions AVG, COUNT, MAX, MIN, and SUM to perform calculations within your SELECT statement to summarize information about groups of rows in a table.

This section contains the following topics:

Aggregate Functions

Eliminating Duplicate Rows

Grouping Information

Using HAVING

Renaming Column Headings

Review

Scenarios