On 29 Feb, 00:42, J <japhyrider2...@yahoo.com> wrote:
> 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?

You are looking for the strawberry query.
http://dev.mysql.com/doc/refman/5.0/...group-row.html
Look at the LEFT JOIN example (NOT the subselect)