查询不及格科目大于2学号、学生姓名

select sno,count(0) from student where score <60 group by sno having count(0)>1 select* from ( select ROW_NUMBER() over( order by score desc) as r , * from student )t select * from student where sno in( select sno from student where score <60 group by sno,sname having count(0)>1 ) order by sno desc , cno asc