SELECT * from(SELECT system, TIMEDAY, CATEGORY, COUNT (CASE WHEN state = '关闭' THEN '关闭' ELSE NULL END) 关闭数, COUNT (CASE WHEN state = '正在进行' THEN '正在进行' ELSE NULL END) 正在进行数, COUNT (CASE WHEN state = '超时' THEN '超时' ELSE NULL END) 超时数, COUNT (CASE WHEN state = '延期完成' THEN '延期完成' ELSE NULL END) 延期完成数 FROM table GROUP BY system,TIMEDAY,CATEGORY)where to_char(TIMEDAY,'yyyyMM') ='${ym}' and CATEGORY='${leibie}'========================比如我只查询了七月份的数据,但是他也会查出来其他月份的数据