15.sql

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

use student_class
select student.*
from student,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and sc.sclass='1'and  cno='2' and grade <=all
(
 select grade 
from sc ,student
where cno='2'and
student.sclass=sc.sclass and student.sno=sc.sno
and sc.sclass='1'
)