Help with simple mysql query please Hello,
I have a mysql table called Points with like :
Name | Grade | Points
Bill | 1 | 5
Tom | 1 | 10
Fred | 2 | 7
Amy | 2 | 3
Ally | 3 | 10
Zoe | 3 | 11
and so on......
I need a query that will return the top point leader by grade.
1 - Tom - 10
2 - Fred - 7
3 - Zoe = 11
Can someone tell me how to do this? |