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

Get OCA Oracle Database 11g SQL Fundamentals I Exam Guide 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.