2,723
社区成员
发帖
与我相关
我的任务
分享
CREATE CURSOR TEST (DATE C(8),NUM N(1),NAME C(4))
CSTR=[20130101,1,张三;20130102,3,张三;20130103,3,李四;20130104,3,李四;20130105,2,张三;20130106,2,王五]
FOR I=1 TO ALINES(A,CSTR,[;])
=ALINES(B,A(I),[,])
INSERT INTO TEST VALUES (B(1),INT(VAL(B(2))),B(3))
ENDFOR
SELECT *,0 FL FROM TEST INTO CURSOR TEST1 READWRITE
NAME1=NAME
N=1
SCAN
IF NAME!=NAME1
N=N+1
ENDIF
NAME1=NAME
REPLACE FL WITH N
ENDSCAN
SELECT NAME,MIN(DATE),MAX(DATE),SUM(NUM),FL FROM TEST1 GROUP BY FL,NAME