原数据               |      希望处理结果        
产品类别    产品编号     |   产品类别        起始编号    结束编号
A              1         |       A            1            3
A              2         |       A            5            6
B              1         |       B            1            2
C              1         |       B            5            7
D              5         |       C            1   
D              7         |       C            3            5
E              1         |       D            5   
A              3         |       D            7            8
B              2         |       E            1            2
B              5         |       E            5   
C              3         |       E            7   
E              2         |      
A              5         |      
E              5         |      
D              8         |
C              4         |
A              6         |
B              6         |
E              7         |
B              7      [local]2[/local]  |

要自己寫邏輯統計代碼的，自己整理一下思路吧，不難的。

索引 产品类别
SCAN
    IF 产品类别 相同 AND 产品编号=上行产品编号+1
    ELSE
    ENDIF
ENDSCAN
剩下自己填一下空格就可以了

在别的论坛也看到过这个贴子

CREATE CURSOR cpfl (cplb c(1),cpbh n(1))
INSERT INTO cpfl VALUES ([A],1)
INSERT INTO cpfl VALUES ([A],2)
INSERT INTO cpfl VALUES ([B],1)
INSERT INTO cpfl VALUES ([C],1)
INSERT INTO cpfl VALUES ([D],5)
INSERT INTO cpfl VALUES ([D],7)
INSERT INTO cpfl VALUES ([E],1)
INSERT INTO cpfl VALUES ([A],3)
INSERT INTO cpfl VALUES ([B],2)
INSERT INTO cpfl VALUES ([B],5)
INSERT INTO cpfl VALUES ([C],3)
INSERT INTO cpfl VALUES ([E],2)
INSERT INTO cpfl VALUES ([A],5)
INSERT INTO cpfl VALUES ([E],5)
INSERT INTO cpfl VALUES ([D],8)
INSERT INTO cpfl VALUES ([C],4)
INSERT INTO cpfl VALUES ([A],6)
INSERT INTO cpfl VALUES ([B],6)
INSERT INTO cpfl VALUES ([E],7)
INSERT INTO cpfl VALUES ([B],7)

SELECT CPLB,MIN(CPBH) 起,MAX(CPBH) 止 FROM (SELECT *,RECNO() XH,ABS(RECNO()-CPBH) CZ FROM (SELECT * FROM CPFL ORDER BY 1,2) A) B GROUP BY CZ,CPLB ORDER BY 1,2

结果：