56,940
社区成员




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