11、查询各科成绩前三名的记录:(不考虑成绩并列情况)

匿名网友 匿名网友 发布于: 2015-12-29 00:00:00
阅读 107 收藏 0 点赞 0 评论 0

SELECT t1.S# as 学生ID,t1.C# as 课程ID,Score as 分数
FROM SC t1
WHERE score IN (SELECT TOP 3 score
FROM SC
WHERE t1.C#= C#
ORDER BY score DESC)
ORDER BY t1.C#;

评论列表
文章目录