mysql中的sql语句

#全选课的学生
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) 
)