## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

## Group Functions

### Exam Objectives

In this chapter, you will learn to

• 061.5.1    Identify the Available Group Functions

• 061.5.2    Describe the Use of Group Functions

• 061.5.3    Group Data by Using the GROUP BY Clause

• 061.5.4    Include or Exclude Grouped Rows by Using the HAVING Clause

Single-row functions, explored in Chapter 8, return a single value for each row in a set of results. Group or aggregate functions operate on multiple rows. They are used to count the number of rows or to find the average of specific column values in a dataset. Many statistical operations, such as calculating standard deviation, medians, and averages, ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required