OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

7

Reporting Aggregated Data Using the Group Functions

CERTIFICATION OBJECTIVES

7.01     Describe the Use of Group Functions

7.02     Group Data by Using the GROUP BY Clause

7.03     Include or Exclude Grouped Rows by Using the HAVING Clause

   ✓        Two-Minute Drill

Q&A     Self Test

In Chapter 5, we looked at single-row functions, which process rows individually and return one answer for each row. This chapter reviews functions and features in SQL that have the ability to process zero or more rows as a logical set, analyzed together to return a single-row result. These functions are referred to as group functions since they accept input from ...