如何统计jsrkb.dbf中各学科的人数（其中姓名有重复），望高手赐教，万分感谢！！！

不计算重复的？

重复的只算一次

** 只能1个个字段分开算，1句话的还没有想到
SELECT COUNT(DISTINCT NJ) as 年级 FROM jsrkb
SELECT COUNT(DISTINCT BJ) as 班级 FROM jsrkb
...

SELECT 班会 DISTINCT FROM jsrkb WHERE !EMPTY(班会) INTO ARRAY  班会S
?ALEN(班会S)

这是计算［班会］

我想，也只能一步步来做，一下子完成恐怕不行的。

[此贴子已经被作者于2020-4-7 09:01编辑过]

未在电脑上测试，请你自己试一试，仅以统计班会为例，其余类似：
SELECT DISTINCT 班会 FROM jsrkb where !empt(班会) INTO CURSOR js
SELECT COUNT(班会) as zrs FROM js into array rc

也可以合成一句：
SELECT COUNT(班会) as zrs FROM (SELECT DISTINCT 班会 FROM jsrkb where !empt(班会)) B INTO ARRAY rc

仅供参考。

[此贴子已经被作者于2020-4-7 08:56编辑过]

或者这样，只几个，其他的，你按格式加，另外，要把你表中的，合计，这个记录删除掉。。
SELECT t1.年级,t2.班级,t3.班会,t4.道德 from ;
(SELECT 1 as id,COUNT(DISTINCT NJ) as 年级 FROM jsrkb) as t1, ;
(SELECT 1 as id,COUNT(*) as 班级 FROM (SELECT DISTINCT NJ,BJ FROM jsrkb) as t0 ) as t2, ; && 班级统计，要用年级+班级
(SELECT 1 as id,COUNT(DISTINCT 班会) as 班会 FROM jsrkb) as t3, ;
(SELECT 1 as id,COUNT(DISTINCT 道德) as 道德 FROM jsrkb) as t4 ;
WHERE t1.id=t2.id AND t1.id=t3.id AND t1.id=t4.id

CLOSE DATABASES 
USE jsrkb
BLANK FOR RECNO() = RECCOUNT()
FOR i = 3 TO FCOUNT()
    INDEX on EVALUATE(FIELD(i)) TO aa UNIQUE FOR NOT EMPTY(EVALUATE(FIELD(i)))
    COUNT TO hj
    SET ORDER TO 
    REPLACE RECORD RECCOUNT() (FIELD(i)) WITH TRANSFORM(hj), nj WITH "合计"
ENDFOR
BROWSE 
USE 
ERASE aa.idx

[此贴子已经被作者于2020-4-7 10:10编辑过]

SET SAFETY OFF 
SET ENGINEBEHAVIOR 70
CREATE TABLE xkrstj (xkmc c(10),rs n(3))
CLOSE DATABASES 
SELECT 0
USE xkrstj ALIAS tj
SELECT 0
USE jsrkb ALIAS kb
FOR i=3 TO FCOUNT()
  zdm=FIELD(i)
  SELECT EVALUATE(zdm) as kg FROM kb  INTO TABLE tmp
  SELECT tmp
  SELECT kg FROM tmp WHERE !EMPTY(kg) GROUP BY kg INTO CURSOR ttt
  SELECT ttt
  nn=RECCOUNT()
  SELECT tj
  APPEND BLANK 
  REPLACE xkmc WITH zdm,rs WITH nn
  SELECT ttt
  USE 
  SELECT tmp
  USE 
  SELECT kb
ENDFOR 
SELECT tj
BROWSE

合计数写到JSRKB上的话一统计 就改变了JSRKB表的记录数，在课表处理时，就会出错。

表尾写合计是数据处理的大忌。