2,698
社区成员




CREATE CURSOR 表(xm C(10), dw C(10), fs1 N, fs2 N, fs3 N, fs4 N, fs5 N, fs6 N, fs7 N, fs8 N, fs9 N, fs10 N, df N(10,2))
INSERT INTO 表 VALUES ('张三', '一中', 80, 90, 95, 85, 82, 82, 80, 81, 90, 80, 0)
INSERT INTO 表 VALUES ('李四', '二中', 80, 90, 94, 85, 94, 82, 82, 81, 90, 80, 0)
SCAN
SCATTER TO ar
CREATE CURSOR tmp (df N)
FOR i=3 TO ALEN(ar)
IF ar[i] > 0
INSERT INTO tmp VALUE (ar[i])
ENDIF
NEXT
SELECT (SUM(df) - MAX(df) - MIN(df)) / COUNT(*) AS df FROM tmp INTO ARRAY r
SELECT 表
REPLACE df WITH r[1]
ENDSCAN