亲人们，我又来了！

ChengJi.dbf表的结构如下：
成绩ID  班级  语文
1       1     90
2       1     92
3       1     89
4       1     93
5       1     72
6       1     87
7       1     75
8       2     89
9       2     94
10      2     67
11      2     72
12      2     85
13      2     90
14      2     85
15      3     89
16      3     86
17      3     81
18      3     74
19      3     91
20      3     96
21      3     74

我想用Select出每个班的语文成绩前三名，共9条记录（三个班，每班前三甲），请问这个语句该怎么写呢？
我用SQL Server能实现，但同样的语句在VFP里却不好使。

为了方便亲人们测试，我把测试数据发在下面了。

CREATE CURSOR ChengJi (成绩ID INT, 班级 INT, 语文 INT)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (1,1,90)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (2,1,92)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (3,1,89)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (4,1,93)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (5,1,72)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (6,1,87)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (7,1,75)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (8,2,89)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (9,2,94)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (10,2,67)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (11,2,72)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (12,2,85)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (13,2,90)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (14,2,85)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (15,3,89)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (16,3,86)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (17,3,81)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (18,3,74)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (19,3,91)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (20,3,96)
INSERT INTO ChengJi (成绩ID, 班级, 语文) VALUES (21,3,74)

[此贴子已经被作者于2018-8-25 20:21编辑过]

想要什么结果呢？你没说哎

* 找出了一段代码示例，不知是否符合楼主的要求
CREATE CURSOR  tt (班级 c(10),学号 c(10),成绩 n(3))
INSERT INTO tt VALUES ("01","X0101",86)
INSERT INTO tt VALUES ("01","X0102",92)
INSERT INTO tt VALUES ("01","X0103",72)
INSERT INTO tt VALUES ("01","X0104",86)
INSERT INTO tt VALUES ("02","X0201",75)
INSERT INTO tt VALUES ("02","X0202",81)
INSERT INTO tt VALUES ("02","X0203",72)
INSERT INTO tt VALUES ("02","X0204",73)
INSERT INTO tt VALUES ("03","X0204",74)
* 分组前3名
SELECT A.班级,A.学号,A.成绩 FROM tt A WHERE 3>(SELECT COUNT(*) FROM tt WHERE 班级=A.班级 AND 成绩>A.成绩) ORDER BY a.班级,成绩 DESC

[此贴子已经被作者于2018-8-25 17:32编辑过]

谢谢大侠，又一次得到您的帮助，非常感谢！
未能及时回复，请见谅！