table Aid uid status
1 1 1
2 1 0
3 1 1
4 2 0
5 2 0
6 2 1
7 3 0
8 3 1
现在要统计出这个结果uid status_1 status_0
1 2 1
2 1 2
3 1 1按uid分组,统计每个uid的status状态分别为0 和分别为1的数量sql该如何写呢
1 1 1
2 1 0
3 1 1
4 2 0
5 2 0
6 2 1
7 3 0
8 3 1
现在要统计出这个结果uid status_1 status_0
1 2 1
2 1 2
3 1 1按uid分组,统计每个uid的status状态分别为0 和分别为1的数量sql该如何写呢
解决方案 »
- mysql最新版是几点几的哪里可以下载
- 请问这条命令哪里写错了?谢谢,涛涛:)
- postgresql 没有 replace into 吗?
- mysql5.0命令行方式不能连接数据库
- 我才接触mysql数据库,常碰到问题,希望大家多多帮助,QQ:1099135
- 请问谁有mysql数据库方面的资料或网址,给我发一个,本人对mysql数据库初学。
- C连接mysql出现的问题!
- mysql not in 的优化问题
- 既有逗号关联,又有INNER JOIN关联;逗号关联的两个表调换一下顺序,执行结果就不一样了?
- mysql报错
- 如何提升mysql数据库操作效率
- lovCombo setValue() 设置值怎么不好用?
select uid, sum(if(status=1, 1, 0)) as status_1, sum(if(status=0, 1, 0)) as status_0
from A
group by uid
或
select uid, count(if(status=1, 1, null)) as status_1, count(if(status=0, 1, null)) as status_0
from A
group by uid
from A
group by uid
select count(uid) from A where status=0 group by uid
union all
select count(uid) from A where status=1 group by uid;
from A
group by uid
from A
group by uid