17.sql

来自「大学时做的数据库实验」· SQL 代码 · 共 13 行

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
)