开发者

How to get unique result in mysql

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜