|
|
GROUP BYBreaks all records into groupsSELECT category, COUNT(category) FROM People GROUP BY category The SQL Statement above will retrieve category and number of records in each category: SELECT category, COUNT(category) From the table named People: FROM People broken down by category:GROUP BY category If this is the original table
Your recordset returned would be this:
| |||||||||||||||||||||||||||||||||