select 字母,'1000以内',1000
from table
where 数字<=1000
union all
select 字母,'1000-1100',100
where 数字>1000 and 数字<=1100
select 字母,'1000-1200',50
where 数字>1000 and 数字<=1200
类似这样要拆几种就union all几种
1min目标场景问卷
立即参与
