主题:[讨论]这个问题该怎么解决?新手求救!!
select sname from student
where sdept=
(select sdept from student
where sno=
(select sno from sc
group by sno
having avg(grade)>=all
(select avg(grade) from sc group by sno)
)
)
当俩个学生的平均成绩相等的时候怎么办?
where sdept=
(select sdept from student
where sno=
(select sno from sc
group by sno
having avg(grade)>=all
(select avg(grade) from sc group by sno)
)
)
当俩个学生的平均成绩相等的时候怎么办?