Working with Groups of Data

Grouping Data

You can use group functions in a SQL statement to display information about groups of rows in the database. A group function performs an operation on a set of data.

Group functions operate on sets of rows and return one result per group. Group functions are also called multiple-row functions (in contrast with single-row functions, which return one result for each row).

You can use a group function to operate on a set of data. The set may be an entire table or only part of the table.

In this section, Sheila creates reports that summarize data.