eharetea

Group results by certain attributes.

Grouping in MySQL.

Date Created:Friday December 29th, 2006 03:41 AM
Date Modified:Friday August 01st, 2008 01:07 AM

some grouping functions:
AVG(), COUNT(), MAX(), MIN(), SUM()

# example of grouping:

mysql>SELECT title, COUNT(*) AS Number
FROM folders, comment
WHERE folders.folder_id = comment.link_id
GROUP BY folders.folder_id;