13Generating Reports by Grouping Related Data
CERTIFICATION OBJECTIVE
13.01 Use the ROLLUP Operation to Produce Subtotal Values
13.02 Use the CUBE Operation to Produce Crosstabulation Values
13.03 Use the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE
13.04 Use GROUPING SETS to Produce a Single Result Set
This chapter is about a number of extensions to the capabilities of the GROUP BY clause of the SELECT statement, CUBE, ROLLUP, and GROUPING SETS. We’ll also examine a function named GROUPING that supports the GROUP BY operations discussed in this chapter. Each is addressed separately in the ...
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.
