34,576
社区成员
发帖
与我相关
我的任务
分享
select case when num1=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 isnull(num1,0) when 0 then num2 else num1 end as num3
from A