MS_SQL
select nullif(isnull(A,0)+isnull(B,0),0) as [Sum] from table1
Oracle
用 select case when nvl(A,0)+nvl(B,0)=0 then null else nvl(A,0)+nvl(B,0)end as [Sum] from table1
select nullif(isnull(A,0)+isnull(B,0),0) as [Sum] from table1
Oracle
用 select case when nvl(A,0)+nvl(B,0)=0 then null else nvl(A,0)+nvl(B,0)end as [Sum] from table1