#全选课的学生
select sname
from student s
where not exists
(select * from course c
where not exists
(select * from sc
where sid =s.sid
and sc.cid=c.cid)
)
mysql中的sql语句
最新推荐文章于 2021-06-30 17:54:44 发布
#全选课的学生
select sname
from student s
where not exists
(select * from course c
where not exists
(select * from sc
where sid =s.sid
and sc.cid=c.cid)
)