如何用sql实现两个字段相加?_sql两个字段相加-CSDN博客

网站介绍:MS_SQLselect nullif(isnull(A,0)+isnull(B,0),0) as [Sum] from table1Oracle用 select case when nvl(A,0)+nvl(B,0)=0 then null else nvl(A,0)+nvl(B,0)end as [Sum] from table1以下为样例:_sql两个字段相加