现有表文件ZBB.dbf,如何统计每个人的值班天数? 请高手赐教，万分感谢！！！

是不是每个名字出现的次数

代码供参考:

LOCAL col1 
LOCAL ii
DIMENSION arr1[1]

CLOSE TABLES ALL 
USE zbts IN 0 EXCLUSIVE 
USE zbb IN 0 SHARED 

CREATE CURSOR tmphz (xm C(20) NOT NULL , ts i NOT null)
AFIELDS(arr1 ,'zbb')

ii = 0
FOR ii = 1 TO ALEN(arr1,1) 
    col1 = arr1[ii,1] 
    INSERT INTO tmphz (xm,ts) ;
    SELECT &col1 as xm ,1 as ts FROM zbb 
ENDFOR 

INSERT INTO zbts (姓名, 值班天数) ;
SELECT xm as 姓名,SUM(ts) as 值班天数 FROM tmphz GROUP BY xm

USE IN tmphz

我也是初学者，下面的方法好像很笨，回帖只为做标记，等高手解答。下面两条命令，执行第一条后按CTRL+F2回到命令窗口，再执行第二条：

select OCT＿1 from zbb union all select OCT＿2 from zbb  union all select OCT＿3 from zbb  union all select OCT＿4 from zbb union all select OCT＿5 from zbb  union all select OCT＿6 from zbb  union all select OCT＿7 from zbb

select OCT＿1,count(*) from query group by OCT＿1

@吹水佬 对！就是统计每个名字出现的次数。

SELECT * FROM zbb INTO ARRAY arr
DIMENSION arr[ALEN(arr,1)*ALEN(arr,2),1] 
CREATE CURSOR tmp (姓名 v(10))
INSERT INTO tmp FROM ARRAY arr
SELECT 姓名,COUNT(*) 值班天数 FROM tmp GROUP BY 姓名 ORDER BY 姓名

[此贴子已经被作者于2023-5-18 17:26编辑过]

SELECT * FROM zbb INTO ARRAY azbb
DIMENSION azbb[ALEN(azbb, 0), 1]
CREATE CURSOR test (xm c(10))
INSERT INTO test FROM ARRAY azbb
SELECT xm, COUNT(*) 值班天数 FROM test GROUP BY 1 INTO CURSOR zbts
BROWSE

谢谢各位高手的热心指点！

漂亮