SELECT SUM(DECODE(QUALITY,'严重污染',1,'重度污染',1,0)) ZWR_TS_QN,CITYCODE,AREA
FROM TENV.AIR_CITYDAYAQI_PUBLISH A
WHERE TO_CHAR(TIMEPOINT,'YYYY-MM') >= '2017-10'
AND TO_CHAR(TIMEPOINT,'YYYY-MM-DD') <= '2017-12-05'
GROUP BY CITYCODE,AREA
SELECT COUNT(*) ZWR_TS_QN,CITYCODE,AREA
FROM TENV.AIR_CITYDAYAQI_PUBLISH A
WHERE TO_CHAR(TIMEPOINT,'YYYY-MM') >= '2017-10'
AND TO_CHAR(TIMEPOINT,'YYYY-MM-DD') <= '2017-12-05'
AND A.QUALITY IN ('严重污染','重度污染')
GROUP BY CITYCODE,AREA
注意上面两个sql文件,显示的时候,上面的sql文件能显示严重污染和重度污染的值,包含没有重度污染和严重污染的城市,下面的sql则是把没有重度污染和严重污染的城市
给过滤掉了,只显示有重度污染和严重污染的城市数据!!!