23.sql

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

select sname, grade from sc,student
where cno=2  and student.sno=sc.sno  and student.sclass=sc.sclass  
and student.sno in(select sno  from sc where cno=2)
order by grade desc