select count(1) from ( SELECT DISTINCT sfjh ,qcbh, to_char(xfrq,'yyyy-MM-dd') xfrq FROM icksys.IC_XFJLK@dblink_1 WHERE xfrq >= trunc ( add_months(sysdate,-1), 'MONTH') and xfrq <![CDATA[ < trunc(sysdate, 'MONTH') ]]> AND dwbh = '6100' AND xlbh <![CDATA[ <> '000000' ]]> AND xlbh <![CDATA[ <> '008888' ]]> AND xlbh <![CDATA[ <> '000999' ]]> AND xlbh <![CDATA[ <> '999998' ]]> AND xlbh <![CDATA[ <> '999999' ]]> AND xlbh <![CDATA[ <> '888888' ]]> ) as a
附上错误代码,解决方法去掉 as a