SQL 练习36

  • 查询不同课程成绩相同的学生的学生编号、课程编号、学生成绩
select  a.cid, a.sid,  a.score from sc as a,sc as b
WHERE a.sid = b.sid
and a.cid != b.cid
and a.score = b.score
group by a.cid, a.sid,a.score
posted @ 2021-08-20 19:58  弩哥++  阅读(40)  评论(0)  编辑  收藏  举报