View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 03:49 PM
J
 
Posts: n/a
Default Help with simple mysql query please

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?
Reply With Quote