13.sql

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

use student_class
select distinct  student.*
from student ,course,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and student.sclass='2' and course.cpno='1' and course.cno=sc.cno