22,302
社区成员




select wzxz as wzxz, count(*) as gs
INTO #tmp from cbs where jsdw='环卫' and xmmc='环卫' group by wzxz
select wzxz as wzxz, count(*) as gs
INTO #tmp from cbs where jsdw='供热站' and xmmc='供热' group by wzxz
SELECT *
INTO #tmp
FROM ( SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '环卫'
AND xmmc = '环卫' and 你需要筛选的条件
GROUP BY wzxz
UNION ALL
SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '供热站'
AND xmmc = '供热' and 你需要筛选的条件
GROUP BY wzxz
) a
SELECT *
INTO #tmp
FROM ( SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '环卫'
AND xmmc = '环卫'
GROUP BY wzxz
UNION ALL
SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '供热站'
AND xmmc = '供热'
GROUP BY wzxz
) a