SELECt t1.S# as 学生ID,t1.C# as 课程ID,Score as 分数
FROM SC t1
WHERe score IN (SELECt TOP 2 score
FROM SC
WHERe t1.C#= C#
ORDER BY score DESC )
ORDER BY t1.C#;
SELECt t1.S# as 学生ID,t1.C# as 课程ID,Score as 分数
FROM SC t1
WHERe score IN (SELECt TOP 2 score
FROM SC
WHERe t1.C#= C#
ORDER BY score DESC )
ORDER BY t1.C#;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
