image

CHAPTER12Grouping Things Together

Up to this point, you’ve seen how SQL can SELECT rows of information from database tables, how the WHERE clause can limit the number of rows being returned to only those that meet certain rules that you define, and how the rows returned can be sorted in ascending or descending sequence using ORDER BY. You’ve also seen how the values in columns can be modified by character, NUMBER, and DATE functions, and how group functions can tell you something about the whole set of rows.

Beyond the group functions you’ve seen, there are also two group clauses: HAVING and GROUP BY. These are parallel to the WHERE and ORDER ...

Get Oracle Database 12c The Complete Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.