展开全部
速度快是不可能了,我就随便按照你32313133353236313431303231363533e59b9ee7ad9431333332633633说的列点数据,只取前两名,你领会一下吧
建表及数据create table sc
(sno int,
cno int,
score);
insert into sc values (1,1,100);
insert into sc values (2,1,80);
insert into sc values (3,1,25);
insert into sc values (4,1,45);
insert into sc values (5,1,67);
insert into sc values (1,2,25);
insert into sc values (2,2,77);
insert into sc values (3,2,78);
insert into sc values (4,2,69);
insert into sc values (5,2,24);
执行select sno,cno,score
from sc r1
where (select count(1) from sc r2 where r2.cno=r1.cno and r2.score >= r1.score) <=2;
结果截图