OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition

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, such ...