我的语句是select nvl(count(operator_work_no),0) from bu_malf_status_info where operator_work_no is not null and
to_char(operator_date,'yyyy-mm-dd')=to_char(sysdate,'yyyy-mm-dd')
and status=108353467 and parent_id in(
select id from bu_malfunction_temp where malf_type=160953413)
group by operator_work_no,里面的字段大家不理解,我的问题是有了GROUP BY,最好的值就为空,去掉GROUP BY 就有0这个值