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
;