表结构(T):<table>
name status
a 1
a 1
a 0
b 1
b 1
c 1
</table>查询:select name,count(1) as count from T group by name;结果:a 3
b 2
c 1查询:select count(1) from T where status=1 group by name;结果:2
2
0如何将这2个结果集合并成一个:a 3 2
b 2 2
c 1 0
name status
a 1
a 1
a 0
b 1
b 1
c 1
</table>查询:select name,count(1) as count from T group by name;结果:a 3
b 2
c 1查询:select count(1) from T where status=1 group by name;结果:2
2
0如何将这2个结果集合并成一个:a 3 2
b 2 2
c 1 0
解决方案 »
- C连接MYSQL源码
- 有一个数据表,其中一个字段是type_id,是用来存储所属类别的
- mysql 数据库丢失
- python yaml 中文问题
- 用source运行.sql文件出错
- mysql问题,急!
- 请教:Mysql在Linux下设置驱动的路径??
- 请问这种情况如何简表查询效率最高?
- 自己写了个php重置游戏内角色技能及天赋的功能,但是在PHP内无法执行,SQL语句在mysql里是有效的,求解!
- 求助,window下mysql如何使用udf
- [Err] 1286 - Unknown storage engine 'ndbcluster'
- Mysql5.7的中文全文索引功能怎么样?谁用过呢?
我想把这两个结果集拼成一个结果集返回给后台,不想分两次返回
select name,count(1) as count from T group by name;
集合二:
select name,count(1) from T where status=1 group by name;再按name进行连接
from T
group by name;
版主,假如status是其他种类的字段,不能用sum的话该如何写
from (select name,count(1) as count from T group by name)as a ,
(select name,count(1) from T where status=1 group by name) as b
where a.name=b.name;