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