13Generating Reports by Grouping Related Data
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
Q&A Self Test
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 ...