select (case when jzbs =1 then '已建账'when jzbs=0 then '未建' end) as 建账标识 from tab_ks as a or select 建账标识 = (case when jzbs =1 then '已建账'when jzbs=0 then '未建' end) from tab_ks as a
select (case when jzbs =1 then '已建账'when jzbs=0 then '未建' end) as 建账标识 from tab_ks as a or select 建账标识 = (case when jzbs =1 then '已建账'when jzbs=0 then '未建' end) from tab_ks as a
select case when jzbs =1 then '已建账' when jzbs=0 then '未建' end as 建账标识 from tab_ks as a别名应在end之后使用
or
select 建账标识 = (case when jzbs =1 then '已建账'when jzbs=0 then '未建' end) from tab_ks as a
or
select 建账标识 = (case when jzbs =1 then '已建账'when jzbs=0 then '未建' end) from tab_ks as a
when jzbs =1 then '已建账'
when jzbs=0 then '未建'
end as 建账标识 from tab_ks as a别名应在end之后使用