检索出sc表中至少选修了’C001’与’C002’课程的学生学号。
select a.sno '学号'
from (select * from sc where (cno = 'C001')) a
inner join
(select * from sc where (cno = 'C002')) b
on a.sno = b.sno
`
检索出sc表中至少选修了’C001’与’C002’课程的学生学号。
select a.sno '学号'
from (select * from sc where (cno = 'C001')) a
inner join
(select * from sc where (cno = 'C002')) b
on a.sno = b.sno
`