Hour 10. Sorting and Grouping Data

Team-Fly

---

 

	Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
	Table of Contents
	Part III.  Getting Effective Results from Queries

---

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

---

Team-Fly

Top