Contents Index About this chapter Applying aggregate functions to grouped data

ASA Getting Started
  Selecting Aggregate Data

A first look at aggregate functions


Aggregate functions return a single value for a set of rows. If there is no GROUP BY clause, an aggregate function returns a single value for all the rows that satisfy other aspects of the query.

List the number of employees in the company

List the number of employees in the company and the birth dates of the oldest and youngest employee

The functions COUNT, MIN, and MAX are called aggregate functions, which are functions that summarize information. Other aggregate functions include statistical functions such as AVG, STDDEV, and VARIANCE. All but COUNT have the name of a column as a parameter.

For more information, see Aggregate functions.


Contents Index About this chapter Applying aggregate functions to grouped data