OCA Oracle Database 11g SQL Fundamentals I Exam Guide

CERTIFICATION OBJECTIVES

6.01    Describe the Group Functions

6.02    Identify the Available Group Functions

6.03    Group Data Using the GROUP BY Clause

6.04    Include or Exclude Grouped Rows Using the HAVING Clause

        Two-Minute Drill

Q&A   Self Test

 

Single-row functions, explored in Chapters 4 and 5, 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, ...