用case when 条件 then xxx
when..............then
when..............then
end
eg:
select t.taxpayerid,
case
when t.taxpayerver = '1' then
'dddd'
when t.taxpayerver = '3' then
'kkkk'
end,
t.*
from tb_reg_taxpayerbasicinfo t
when..............then
when..............then
end
eg:
select t.taxpayerid,
case
when t.taxpayerver = '1' then
'dddd'
when t.taxpayerver = '3' then
'kkkk'
end,
t.*
from tb_reg_taxpayerbasicinfo t
扫一扫
1070
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
