41、查询每门功成绩最好的前两名
SELECT S.sid, S.sname ,SC2.cid ,SC2.score
FROM student AS S INNER JOIN (
SELECT * FROM (
SELECT * ,
ROW_NUMBER()
41、查询每门功成绩最好的前两名
SELECT S.sid, S.sname ,SC2.cid ,SC2.score
FROM student AS S INNER JOIN (
SELECT * FROM (
SELECT * ,
ROW_NUMBER()