update session.results set tq_qty= case when tq_qty=0 or tq_qty is null then 0 else tq_qty end, | ||||||||
tq_zb= case when tq_zb=0 or tq_zb is null then 0 else tq_zb end, | ||||||||
zbadd= case when zbadd=0 or tq_zb is null then 0 else zbadd end; |
报表本年对应的上一年数据为空时,将空转换为0
最新推荐文章于 2022-11-08 16:14:49 发布