Sams Teach Yourself SQL in 24 Hours, Second Edition

Hour 10. Sorting and Grouping Data

You have learned how to query the database and return data in an organized fashion. You have learned how to sort data from a query. During this hour, you learn how to break returned data from a query into groups for improved readability.

The highlights of this hour include

• Why you would want to group data

• The GROUP BY clause

• Group value functions

• The how and why of group functions

• Grouping by columns

• GROUP BY versus ORDER BY

• The HAVING clause