7Reporting Aggregated Data Using the Group Functions

CERTIFICATION OBJECTIVES

7.01 Identify the Available Group Functions

7.02 Describe the Use of Group Functions

7.03 Group Data by Using the GROUP BY Clause

7.04 Include or Exclude Grouped Rows by Using the HAVING Clause

Image Two-Minute Drill

Q&A Self Test

This chapter reviews the features in SQL that identify individual rows in a given table and aggregate summary information about them. We’ll look at aggregate functions, and also at two new clauses in the SELECT statement: the GROUP BY clause and its companion, the HAVING clause. You will need to fully understand these capabilities in order to pass ...

Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) 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.