那种写法是对的?
1, selectdescr ,a,b,c from
(select case
when descr like'%...%' then ' '
when descr like'%...%' then ' '
end
descr,a,b,c
fromx)
2,
selectdescr ,a,b,c from
(selectdescr=case
when descr like'%...%' then ' '
when descr like'%...%' then ' '
end,a,b,c
fromx) |