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?

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?

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)

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!

Captain Paralytic 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/...group-row.html
> Look at the LEFT JOIN example (NOT the subselect)
Using the above link I used ...

select Name,Grade,points from Test1 t1
where points = (select max(points) from Test1 t2
where t1.Grade = t2.Grade)
order by Grade
;

Joe Beasley wrote:
> Captain Paralytic 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/...group-row.html
>> Look at the LEFT JOIN example (NOT the subselect)
> Using the above link I used ...
>
> select Name,Grade,points from Test1 t1
> where points = (select max(points) from Test1 t2
> where t1.Grade = t2.Grade)
> order by Grade
> ;

Wrong one!!!!

The section itself (as did I) points out that the correct one to use is the
LEFT JOIN. It is far more efficient!