根据分级码一级级合计金额
比如10001为第一级，它的金额数应该是100010001和100010002的合计，而100010001为第二级，它的金额数应该是1000100010001-6的合计

select SUBSTRING(FJM,1,5) as FJM,SUM(money) as money
from
(select SUBSTRING(FJM,1,9) as FJM,SUM(money) as money
from t
group by SUBSTRING(FJM,1,9))
T
group by SUBSTRING(FJM,1,5)
union
select SUBSTRING(FJM,1,9) as FJM,SUM(money) as money
from t
group by SUBSTRING(FJM,1,9) having SUM(money)>0