Working with Groups of 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.
|