SQL
2019-06-15 本文已影响0人
WhyDoWeLive
1. 查询各科成绩均在80分以上的学生姓名
student.png
select name from (
select name, min(score) from student
group by name
having min(score) > 80
) stuselect name from (
select name, min(score) from student
group by name
having min(score) > 80
) stu
