
June 3rd, 2000, 09:26 AM
|
|
BrainFreeze
|
|
Join Date: May 2000
Location: London
Posts: 318
Time spent in forums: 3 h 41 m 9 sec
Reputation Power: 13
|
|
|
I have 1 table, with 80 teams in, they fall into 7 age groups, also contained is points, goals for etc, I have hence created league tables for the varying age groups.
I now want to list the top teams in each age group in a single table, i.e. the best teams on one page.
I understand i need to select one team from each age group where points is max, if points are equal the point ratio is used to govern who is top - I have looked all over mysql.com and cant find an answer. Thank you all
|