23.sql

大学时做的数据库实验

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