On Feb 29, 1:23*am, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> 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...column-group-r...
> Look at the LEFT JOIN example (NOT the subselect)- Hide quoted text -
>
> - Show quoted text -

Thanks for the replies. Thats what I was looking for!