sql Ôõô½«0ת³Énull

ÎÒÔÚ²éѯµÄʱºò
select Name,sum(Amount) from tb group by Name

½á¹û£º

aa    5
bb    0
cc    0
dd    10


Ôõô½«0ת³Énull»òÕß""

---

update  table  set    ×ֶΠ is  null  where ×Ö¶Î=0

---

SQL code:
select Name,sum(isnull(Amount,0)) from tb group by Name

---

SQL code:
select Name,
case when sum(Amount)<>0 then rtrim(sum(Amount)) else null end as col
from tb group by Name

ÊÔÊÔ

---

ÎÒµÄÒâ˼ÊÇÔÚ²éѯµÄʱºòת»»Îªnull
¶ø²»ÊǸü¸Ä±íÀïµÄÐÅÏ¢

---

SQL code:
create table #TT
(
bb int
)
insert into #TT select 0

select (case when bb=0 then null else 1 end) from #TT


-----------
NULL

(1 ÐÐÊÜÓ°Ïì)

---

ÒýÓÃ

SQL codeselect Name,sum(isnull(Amount,0))from tbgroupby Name

SQL code:
select
Name,
case when sum(Amount)=0 then null else sum(Amount) end
from tb
group