SELECT 1
use pmb
**表结构(ID N 4 ZF N 4 MC N 6)
INDEX ON ZF TAG ZF DESCENDING &&降序
copy to pmb1
SELECT 2
use pmb1
Y=1 && 分数最高者名次(mc)为1
X=ZF
FOR I=1 TO RECCOUNT()
GO I
REPLACE MC WITH IIF(ZF=X,Y,RECNO())
Y=MC
X=ZF
ENDFOR
结果见下图
点击打开链接
将PMB1的MC结果转回到PMB中,代码如下
SELECT 2
FOR I=1 TO RECCOUNT()
GO I
SELECT 1
REPLACE MC WITH B.MC FOR ID=B.ID
SELECT 2
ENDFOR
SELECT 1
SET ORDER TO
GO TOP
brow