O'Reilly logo

SQL Fundamentals, Third Edition by John J. Patrick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Controlling the Level of Summarization

In chapter 11, we summarized all the data in a column of a table. The result was a single value. In this chapter, we divide the rows of the table into groups, which are nonoverlapping sets of rows. Each group is summarized separately, resulting in a summary value for each of the groups.

At our discretion, we can either summarize a column into a single value or divide it into 100 pieces and summarize each piece. This gives us control over the level of detail we want to see.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required