CHAPTER 9
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, ...
Get OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
