I have table:
name marks
aaa 100
aaa 56
aaa 120
bbb 56
bbb 60
开发者_如何学C
The result should be:
aaa 120
bbb 60
ie unique name with maximum marks. Is there any query in mysql?
SELECT name, MAX(marks) marks
from table
group by name
精彩评论