qq_24338943的博客

原创 查询学过学号为“s001”同学所有门课的其他同学学号和姓名

SELECT DISTINCT A.SNO, A.SNAME FROM STUDENT A JOIN SC B ON A.SNO = B.SNO AND B.CNO IN (SELECT C.CNO FROM SC C WHERE C.SNO = 's001') --列出s001 学过的课程 AND B.CNO NOT IN (SELECT CNO FROM COURSE MINUS SELECT CNO FROM SC WHERE SNO = 's001') ...