August 2017
Intermediate to advanced
832 pages
15h
English

7.01 Describe the Use of Group Functions
7.02 Group Data by Using the GROUP BY Clause
7.03 Include or Exclude Grouped Rows by Using the HAVING Clause
In Chapter 5, we looked at single-row functions, which process rows individually and return one answer for each row. This chapter reviews functions and features in SQL that have the ability to process zero or more rows as a logical set, analyzed together to return a single-row result. These functions are referred to as group functions since they accept input from ...
Read now
Unlock full access