--猜一個
select oTotalAmount/100 as tmp, count(oCode) as cnt
from 订单表
group by oTotalAmount/100
order by oTotalAmount/100

------解决方案--------------------

探讨

SQL code

--猜一個
select oTotalAmount/100 as tmp, count(oCode) as cnt
from 订单表
group by oTotalAmount/100
order by oTotalAmount/100


------解决方案--------------------
帮顶 ，

------解决方案--------------------
SQL code
--我也来猜一個
select left(oCode,8) as oCode,count(oCode) as oCount
from 订单表
group by left(oCode,8)
order by left(oCode,8)

------解决方案--------------------
探讨

以100为步值，

区间 个数
0-100 50
100-200 56
200-300 89