14.sql

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

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
)