case when 转换下 with tab as (select 0 id from dual union all select 1 from dual union all select 2 from dual union all select 0 from dual union all select 2 from dual ) select id, (case when id >1 then '复投会员数' else '' end) name from tab
列名不对 with tab as (select 0 "累计投资次数" --列名不对应啊 from dual union all select 1 from dual union all select 2 from dual union all select 0 from dual union all select 2 from dual ) select 累计投资次数, (case when 累计投资次数>1 then '复投会员数' else '' end) name from tab
with tab as
(select 0 id from dual union all
select 1 from dual union all
select 2 from dual union all
select 0 from dual union all
select 2 from dual )
select id,
(case when id >1 then '复投会员数'
else '' end) name
from tab
with tab as
(select 0 "累计投资次数" --列名不对应啊
from dual union all
select 1 from dual union all
select 2 from dual union all
select 0 from dual union all
select 2 from dual )
select 累计投资次数,
(case when 累计投资次数>1 then '复投会员数'
else '' end) name
from tab
应该是会显示完整的“复投会员数”,有点迷糊了,大神解答下