J:
> 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?

What's your requirement when multiple 'name' end up in first place for a
grade?