查询学过“叶平”老师所教的所有课的同学的学号、姓名
SELECT sno,sname FROM student s where not exists (select * from course where course.tno=(select tno from teacher where teacher.tname='叶平') and course.cno not in (select course.cno from course,sc where sc.cno=course.cno and sc.sno=s.sno))1.首先查询出叶平老师.
原创
2021-01-22 11:26:32 ·
3872 阅读 ·
6 评论