设价格为price select 价格,count(*) 数量 from( select case when price <100 then ' <100' when price>=100 and price <500 then '100-500' when price>=500 and price <1000 then '500-1000' else '>1000' end 价格, a.* from a) gtoup by 价格
select a.价格,sum(a.数量) 数量 from ( select case when 价格<100 then '<100' when 价格>=100 and 价格<500 then '100-500' when 价格>=500 and 价格<1000 then '500-1000' else '>1000' end 价格, tb1.数量 from tb1 ) a group by a.价格
select a.价格,sum(a.数量) 数量 ,a.种类 from ( select case when 价格<100 then '<100' when 价格>=100 and 价格<500 then '100-500' when 价格>=500 and 价格<1000 then '500-1000' else '>1000' end 价格, tb1.数量 from tb1 ) a group by a.价格,a.种类
select 价格,count(*) 数量
from(
select
case
when price <100 then ' <100'
when price>=100 and price <500 then '100-500'
when price>=500 and price <1000 then '500-1000'
else '>1000'
end 价格,
a.*
from a)
gtoup by 价格
from
(
select
case
when 价格<100 then '<100'
when 价格>=100 and 价格<500 then '100-500'
when 价格>=500 and 价格<1000 then '500-1000'
else '>1000'
end 价格, tb1.数量
from tb1
) a
group by a.价格
select a.价格,sum(a.数量) 数量 ,a.种类
from
(
select
case
when 价格<100 then '<100'
when 价格>=100 and 价格<500 then '100-500'
when 价格>=500 and 价格<1000 then '500-1000'
else '>1000'
end 价格, tb1.数量
from tb1
) a
group by a.价格,a.种类