56,677
社区成员
发帖
与我相关
我的任务
分享
select
case xxx
when 'ABC' then 'abc'
when 'DEF' then 'def'
else 'xxxx' end as xxxx
from table_name
select case when xxx is null then '000' from table_name
select
case
when xxx = 'ABC' then 'abc'
when xxx = 'DEF' then 'def'
when xxx is null then '000'
else 'xxxx' end as xxxx
from table_name