select guid,sum(nvl(DR_AMT,0)-nvl(CR_AM,0)) from tab_name group by guid having sum(nvl(DR_AMT,0)-nvl(CR_AMT,0))<>0
[quote=引用 4 楼 sych888 的回复:] 结果不对? 字段值有NULL select guid,sum(nvl(DR_AMTDR_AMT,0)-nvl(CR_AMTCR_AMT,0)) from tab_name group by guid having sum(nvl(DR_AMTDR_AMT,0)-nvl(CR_AMTCR_AMT,0))<>0
结果不对? 字段值有NULL select guid,sum(nvl(DR_AMTDR_AMT,0)-nvl(CR_AMTCR_AMT,0)) from tab_name group by guid having sum(nvl(DR_AMTDR_AMT,0)-nvl(CR_AMTCR_AMT,0))<>0
[quote=引用 1 楼 sych888 的回复:] select guid,sum(DR_AMTDR_AMT-CR_AMTCR_AMT) from tab_name group by guid having sum(DR_AMTDR_AMT-CR_AMTCR_AMT)<>0
select guid,sum(DR_AMTDR_AMT-CR_AMTCR_AMT) from tab_name group by guid having sum(DR_AMTDR_AMT-CR_AMTCR_AMT)<>0
17,377
社区成员
95,128
社区内容
加载中
试试用AI创作助手写篇文章吧