查詢學過學號為“1”同學所有課程的其他同學學號和姓名
1 回答
哈士奇WWW
TA貢獻1799條經驗 獲得超6個贊
SELECT stu.Sid, stu.Sname FROM Student stu INNER JOIN SC score2
ON (stu.Sid = score2.Sid) WHERE score2.Cid IN (
SELECT Cid FROM SC score WHERE score.Sid = '1' )
GROUP BY stu.Sid, stu.Sname
HAVING COUNT(score2.Cid) = (
SELECT COUNT(1) FROM SC score WHERE score.Sid = '1' ) AND stu.Sid <> '1'
添加回答
舉報
0/150
提交
取消