O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required