2020-08-10
优化SQL语句
5MSQL语句:
select fb.hbbm fb_hbbm,
sum(fb.jfshl) jfshlje,
sum(fb.jfybje) jfybje,
sum(fb.jffbje) jffbje,
sum(fb.jfbbje) jfbbje,
sum(fb.dfshl) dfshlje,
sum(fb.dfybje) dfybje,
sum(fb.dffbje) dffbje,
sum(fb.dfbbje) dfbbje,
0.0 qmshlye,
0.0 qmybye,
0.0 qmfbye,
0.0 qmbbye
from arap_djzb zb
inner join arap_djfb fb on fb.vouchid = zb.vouchid
where zb.dwbm = ‘1003’
and fb.dwbm = ‘1003’
and zb.hzbz = ‘-1’
and zb.dr = 0
and fb.dr = 0
and fb.xgbh = -1
and ((zb.djdl = ‘ys’) or (zb.djdl = ‘sk’))
and ((fb.djdl = ‘ys’) or (fb.djdl = ‘sk’))
and zb.djrq >= ‘2020-06-26’
and zb.djrq <= ‘2020-07-25’
and fb.billdate >= ‘2020-06-26’
and fb.billdate <= ‘2020-07-25’
and ((zb.djzt > -99))
and fb.wldx = 0
and ((fb.hbbm is not null))
group by fb.hbbm


这句SQL该如何优化?
我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
