Arranging data in a manner that's meaningful can be a challenge. Sometimes a simple sort will do it. But sometimes you will need to do more by creating groups to analyse and summarise. Fortunately, SQL offers a number of clauses and operators for sorting, grouping, and summarising. The following tips will help you discern when to sort, when to group, and when and how to summarize.

http://www.builderau.com.au/program/sqlserver/soa/10_tips_for_sorting_grouping_and_summarizing_SQL_data/0%2C339028455%2C339274648%2C00.htm