SELECT zf as 分数,COUNT(*) as 小计 FROM 表 INTO CURSOR T1 GROUP BY zf
SELECT a.分数,SUM(b.分数) 累计 FROM T1 a,T1 b INTO CURSOR T2 WHERE a.分数>=b.分数 group by a.分数
SELECT a.分数,a.小计,b.累计 FROM T1 a,t2 b INTO CURSOR T3 WHERE a.分数=b.分数 Order By a.分数 DESC
SELECT t3
Copy To 1分段统计表.xls Type Xl5
[
本帖最后由 kiff 于 2014-11-19 15:43 编辑 ]