975
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
WWWWA 2013-05-21
- 打赏
- 举报
select state as state1 ,max(total) as max
from (SELECT STATE ,COUNT(*) AS TOTAL FROM member GROUP BY STATE) FOO
group by state
simplesslife 2013-05-21
- 打赏
- 举报
谢谢自己解决了
rucypli 2013-05-20
- 打赏
- 举报
select state as state1 ,max(total) as max
from member
group by state
