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