Abstract
The GROUP BY clause is a venerable member of the SQL statement family. After learning basic SELECT statements, it is one of first specialized parts of SQL that many practitioners cut their teeth on when learning to create aggregations from raw data and transforming that data into useful information.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
If there are no rows in the table, GROUP BY CUBE() returns zero rows.
- 2.
The NVL() function is used to provide a default value for sh.customers.cust_income_level so that output of examples may be easier to compare.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2013 Karen Morton
About this chapter
Cite this chapter
Morton, K., Osborne, K., Sands, R., Shamsudeen, R., Still, J. (2013). Advanced Grouping. In: Pro Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6221-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6221-3_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6220-6
Online ISBN: 978-1-4302-6221-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books