遇到以零作除数错误

[yikun]

table_1
字段1 ,字段2
2 1
2 null
2 0

select 字段１,字段２,字段１/字段２ as 比率 from table_1 order by 比率

显示遇到以零作除数错误

我希望出来的结果是

2 1 2
2 null null
2 0 null

请问怎么写?

[liangCK]

select 字段1,字段2,字段1/nullif(字段2,0) as 比率 from table_1 order by 比率 

[arrow_gx]

select 字段１,字段２,
case 字段２ when 0 then null else 字段１/字段２ end as 比率 
from table_1 order by 比率

[liangCK]

--> liangCK小梁 于2008-08-20
--> 生成测试数据: #table_1
if object_id('tempdb.dbo.#table_1') is not null drop table #table_1
create table #table_1 (字段1 int,字段2 int)
insert into #table_1
select 2,1 union all
select 2,null union all
select 2,0

select 字段1,字段2,字段1/nullif(字段2,0) as 比率 from #table_1 order by 比率 

/*
字段1         字段2         比率
----------- ----------- -----------
2           NULL        NULL
2           0           NULL
2           1           2

(3 行受影响)
*/

[水族杰纶]

case when end

[qiaoqihua]

select 字段１,字段２,CASE 字段２ WHEN 0 THEN NULL ELSE 字段１/字段２ END as 比率 from table_1 order by 比率

[shenlu198806]

楼上高明