14.sql

大学时做的数据库实验

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