Image
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
  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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.