2.1w+
社区成员
- 主页
请教关于CASE WHEN 的一个写法
假设有四个字段A,B,C,D
当A或B为空值时，C取D的值，否则C取自己本身的值
请问用case when可以实现吗？
当A或B为空值时，C取D的值，否则C取自己本身的值
请问用case when可以实现吗？
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
ICrazyBoy 2010-03-12
[Quote=引用 7 楼 fredrickhu 的回复:]
SQL code
select a,b,case when a is null or b is null then d else c end as c from tb
[/Quote]
F姐姐 数据专家已经帮你game over了！
SQL code
select a,b,case when a is null or b is null then d else c end as c from tb
[/Quote]
F姐姐 数据专家已经帮你game over了！
GUOCHENGJUN 2010-03-12
select c=case
when a is null then d
when b is null then d
else c end from 表名
静远 2010-03-12
大家的速度好快！
Mr_Nice 2010-03-12
select case when a is null or b is null then d else c end from tb--小F-- 2010-03-12
select a,b,case when a is null or b is null then d else c end as c from tbSQL77 2010-03-12
select a,
b,
c=case when ISNULL(A,'')='' or ISNULL(B,'')='' then d else c end
from tbsql_sf 2010-03-12
select a,
b,
c=case when a is null or b is null then d else c end
from tb小_爱 2010-03-12
select c=case when a is unll or b isnull then d else c endcsuxp2008 2010-03-12
update table_name
set c=case when (a is null or b is null) then d
else c
end
set c=case when (a is null or b is null) then d
else c
end
sgtzzc 2010-03-12
select a,b,c=case when a is null or b is null then d else c end,d
from tbdawugui 2010-03-12
select case when a is null or b is null then d else c end from tb
