select wm_concat(pj) from (
select distinct
',case when 销售额>=' || 50000-rownum *500 || ‘ and 销售额<=’ || 50000-(rownum+1)*500 || ‘ then ’|| 销售额 || ' end as '
|| 50000-rownum *500|| '-'||50000-(rownum+1)*500 as pj
from 表
)
然后再将这段pj 拼接语句放到你原有case when的地方。
select wm_concat(pj) from (
select distinct
',case when 销售额>=' || 销售额-rownum *500 || ‘ and 销售额<=’ || 销售额-(rownum+1)*500 || ‘ then ’|| 销售额 || ' end as '
|| 销售额-rownum *500|| '-'||销售额-(rownum+1)*500 as pj
from 表
)
然后再将这段pj 拼接语句放到你原有case when的地方。