22,209
社区成员
发帖
与我相关
我的任务
分享
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