[From ZDNet Asia]
The GROUP BY clause is a SQL language construct used to priovide summary data for column returned in a SELECT statement. This functionality groups values from specified fields together, providing a single record of distinct values for each group.
The article continues at
http://www.zdnetasia.com/techguide/storage/0,39045058,62047753,00.htm