O'Reilly logo

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 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

Images

7

Reporting Aggregated Data Using the Group Functions

CERTIFICATION OBJECTIVES

7.01     Describe the Use of Group Functions

7.02     Group Data by Using the GROUP BY Clause

7.03     Include or Exclude Grouped Rows by Using the HAVING Clause

   ✓        Two-Minute Drill

Q&A     Self Test

In Chapter 5, we looked at single-row functions, which process rows individually and return one answer for each row. This chapter reviews functions and features in SQL that have the ability to process zero or more rows as a logical set, analyzed together to return a single-row result. These functions are referred to as group functions since they accept input from ...

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