Chapter 3. Using Group Functions
ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Reporting Aggregated Data Using the Group Functions
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude the grouped rows by using the HAVING clause
As explained in the previous chapter, functions are programs that take zero or more arguments and return a single value. The exam focuses on two types of functions: single-row and aggregate (group) functions. Single-row functions were covered in Chapter 2, "Using Single-Row Functions." Group functions are covered in this chapter.
Group functions differ from single-row functions in how they are evaluated. Single-row ...
Get OCA Oracle® Database 11g Administrator Certified Associate: Study 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.
