20.sql

大学时做的数据库实验

use student_class
select distinct student.sclass ,student.sno
from student ,sc x,sc y
where student.sclass=x.sclass and student.sno=x.sno
and x.cno='1'and y.sclass=x.sclass and y.sno=x.sno and
y.cno ='2'