区间的数据统计该怎么实现？
是个销售的数据库，该表的结构如下
spbh --表示商品编号
dj --表示该商品的单价
sl --销售数量
rq --发生该销售的日期
想统计各个价格区间在某个月的销售量，一次得出结果
比如：想一次统计出价格在0-10，11-20，21-30，31-40，> 40的商品销售量。
请教各位高手，这个该怎么做，用GROUP BY 似乎行不通啊
[解决办法]
select spbh,定价=case when dj between 0 and 10 then '0-10 '
when dj between 11 and 20 then '11-20 '
when dj between 21 and 30 then '21-30 '
else '> 40 ' end,[销售数量]=sum(sl)
from 表
group by spbh,case when dj between 0 and 10 then '0-10 '
when dj between 11 and 20 then '11-20 '
when dj between 21 and 30 then '21-30 '
else '> 40 ' end,[销售数量]=sum(sl)
order by 定价 asc
[解决办法]
--try
select spbh,
[0-10]=sum(case when dj between 0 and 10 then sl else 0 end),
[11-20]=sum(case when dj between 11 and 20 then sl else 0 end),
[21-30]=sum(case when dj between 21 and 30 then sl else 0 end),
[31-40]=sum(case when dj between 31 and 40 then sl else 0 end),
[> 40]=sum(case when dj> 40 then sl else 0 end)
from tbName
group by spbh
