Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 7. Pivot, Unpivot, and Grouping Sets
Chapter 7. Pivot, Unpivot, and Grouping Sets
| In this chapter: |
| Section 7.1 |
| Section 7.2 |
| Section 7.3 |
| Section 7.4 |
| Section 7.5 |
| Section 7.6 |
This chapter covers techniques for pivoting and unpivoting data and handling grouping sets. Pivoting means rotating data from a state of rows to a state of columns. Unpivoting means rotating data from a state of columns to a state of rows. Grouping sets are sets of attributes that you group by, and this chapter will cover techniques for requesting multiple grouping sets in the same query.
