mysql 查询每门功成绩最好的前两名_在SQL SERVER中，怎样查询每门功课成绩最好的前两名，帮我写一下，谢谢，请补充:...

createtableSC(S#varchar(10),/*学号C#varchar(10),/*课号scoredecimal(18,1)/*成绩)insertintoscvalues('01','01',80)insertintoscvalues('01','02',90)insertintoscvalues('01','03...

create table SC(

S# varchar(10), /*学号

C# varchar(10), /*课号

score decimal(18,1) /*成绩

)

insert into sc values('01' , '01' , 80)

insert into sc values('01' , '02' , 90)

insert into sc values('01' , '03' , 99)

insert into sc values('02' , '01' , 70)

insert into sc values('02' , '02' , 60)

insert into sc values('02' , '03' , 80)

insert into sc values('03' , '01' , 80)

insert into sc values('03' , '02' , 80)

insert into sc values('03' , '03' , 80)

insert into sc values('0