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!