2020-02-16 标签:oracle,下一,sql,语句,优化,过程,比较,详细,原来,这样的,select,sum,sl,0000,xstfxps,dhao,00

原来的语句是这样的： 　　select sum(sl0000) from xstfxps2 where 　　dhao00 in ( 　　select dhao00 from xstfxps1 where trunc(ywrq00)=trunc(sysdate) 　　and khdm00='50000