这句话哪里错了,请指点(实现groub by 后取最大值)

simplesslife 2013-05-20 10:52:42
...全文
58 点赞 收藏 3
写回复
3 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
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
回复
相关推荐
发帖
PostgreSQL
创建于2012-11-23

804

社区成员

PostgreSQL相关内容讨论
申请成为版主
帖子事件
创建了帖子
2013-05-20 10:52
社区公告
暂无公告