81,092
社区成员
发帖
与我相关
我的任务
分享
select
distinct dc,
count(*) heji,
(select count(*) from test t1 where t1.dc = t.dc and t1.type = 'qw') type(qw),
(select count(*) from test t1 where t1.dc = t.dc and t1.type = 'w') type(w)
from test t group by dc