with b as (
select 1 as a from dual
union all
select 2 as a from dual
union all
select 3 as a from dual
)
select case when a =1 then 'A' when a = 2 then 'B' else null end
from b
select case when province in ('....') then '华北'
when province in ('....') then '华东'
else null end as province
from dbo.oncontract
1min目标场景问卷
立即参与
