Hour 9. Summarizing Data Results from a Query

What You’ll Learn in This Hour:

What functions are

How functions are used

When to use functions

Using aggregate functions

Summarizing data with aggregate functions

Results from using functions

In this hour, you learn about SQL’s aggregate functions. You can perform a variety of useful functions with aggregate functions, such as getting the highest total of a sale or counting the number of orders processed on a given day. The real power of aggregate functions will be discussed in the next hour when we tackle the GROUP BY clause.

What Are Aggregate Functions?

Functions are keywords in SQL used to manipulate values within columns for output purposes. A function is a command normally used ...

Get Sams Teach Yourself SQL in 24 Hours, Fifth Edition 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.