17.sql

大学时做的数据库实验

select *
from student
where exists
(
 select *
from sc
where cno in
(
select cno
from sc
where sclass='1'and  sno='2'
) and sno=student.sno and sclass=student.sclass
)