mysql某列值最大的行,如何在MySQL中为列选择最大值的行？

*None of other available answers solved my problem

I have a table t like this

id,cc,count

'1','HN','22'

'1','US','18'

'1','VN','1'

'2','DK','2'

'2','US','256'

'3','SK','1'

'3','US','66310'

'4','UA','2'

'4','US','263'

'6','FR','7'

'6','US','84'

'9','BR','3'

I want to get the rows for ids with maximum count, like below:

id,cc,count

'1','HN','22'

'2','US','256'

'3','US','66310'

'4','US','263'

'6','US','84'

'9','BR','3'

My current code is like this but I am not getting the expected results:

SELECT t.* FROM t

JOIN (

SELECT

t.id,t.cc

,max(t.count) as max_slash24_count

FROM t

group by t.id,t.cc

) highest

ON t.count = highest.max_slash24_count

and t.cc = highest.cc

Can anybody help me out?

解决方案

Remove CC column from group by. Try this.

SELECT t.* FROM t

JOIN (

SELECT

t.id

,max(t.count) as max_slash24_count

FROM t

group by t.id

) highest

ON t.count = highest.max_slash24_count

and t.id= highest.id