SELECT '00' LB,'一、在岗人员总数' DQZT,
COUNT(A.ZGBH) TOTAL,COUNT(DECODE(A.XB,'2',ZGBH)) WOMEN,
LY1.num
from (select COUNT(zgbh) num from RDDRTZ where to_char(drrq,'yyyymm')=
to_char(sysdate,'yyyymm') and DRLB IN ('04','05,','06','07','11')
) LY1,(select * from rdjbda where a.zgbh='0') A
COUNT(A.ZGBH) TOTAL,COUNT(DECODE(A.XB,'2',ZGBH)) WOMEN,
LY1.num
from (select COUNT(zgbh) num from RDDRTZ where to_char(drrq,'yyyymm')=
to_char(sysdate,'yyyymm') and DRLB IN ('04','05,','06','07','11')
) LY1,(select * from rdjbda where a.zgbh='0') A
SELECT '00' LB,'一、在岗人员总数' DQZT,
COUNT(A.ZGBH) TOTAL,COUNT(DECODE(A.XB,'2',ZGBH)) WOMEN,
sum((select COUNT(zgbh) from RDDRTZ where to_char(drrq,'yyyymm')=
to_char(sysdate,'yyyymm') and DRLB IN ('04','05,','06','07','11')
)) LY1
from rdjbda A where a.zgbh='0'
select COUNT(zgbh) from RDDRTZ where to_char(drrq,'yyyymm')=
to_char(sysdate,'yyyymm') and DRLB IN ('04','05,','06','07','11')
所以其他字段要么使用聚集函数要么出现在group by子句中。