81,090
社区成员
发帖
与我相关
我的任务
分享
select sum(if(type=1,1,0))as newsgnum,sum(if(type=2,1,0))as newjlnum,sum(if(type=3,1,0))as newjsnum,sum(if(type=4,1,0))as newjcnum,sum(if(type=5,1,0))as newkcnum,sum(if(type=6,1,0))as newzxnum,sum(if(type=7,1,0))as newzbnum,sum(if(type=8,1,0))as newclnum,sum(if(type=9,1,0))as newbxnum from userg where time>'2012-01'
select * from
(select count(*) as newsgnum from userg where time > '2012-01' and type='1') sg
,
(select count(*) as newjlnum from userg where time > '2012-01' and type='2') jl
,
(select count(*) as newjsnum from userg where time > '2012-01' and type='3') js
,
(select count(*) as newjcnum from userg where time > '2012-01' and type='4') jc
,
(select count(*) as newkcnum from userg where time > '2012-01' and type='5') kc
,
(select count(*) as newzxnum from userg where time > '2012-01' and type='6') zx
,
(select count(*) as newzbnum from userg where time > '2012-01' and type='7') zb
,
(select count(*) as newclnum from userg where time > '2012-01' and type='8') cl
,
(select count(*) as newbxnum from userg where time > '2012-01' and type='9') bx
SELECT type,COUNT(*) FROM userg GROUP BY type ORDER BY type ASC;
select count(*) from user where inputtime = '2012-12' group by type;