表中有三个数字字段如下
table A
id,uname,num1,num2
1, 啊 10 0
2, 啊2 0 20
3, 啊1 15 20 select case num1 when isnull(num1,0) then num2 else num1 end as num3
from A希望结果为
num3
10
20
15
但是结果为
0
20
0
table A
id,uname,num1,num2
1, 啊 10 0
2, 啊2 0 20
3, 啊1 15 20 select case num1 when isnull(num1,0) then num2 else num1 end as num3
from A希望结果为
num3
10
20
15
但是结果为
0
20
0
select case isnull(num1,0) when 0 then num2 else num1 end as num3
from A
select case num1 when num1=0 then num2 else num1 end as num3
from A
select case when num1=0 then num2 else num1 end as num3
from A