方法一:
先按名字分组,再在分组中过滤到成绩小于80的同学的名字
select name from student
group by name
having name not in (
select name from student
where score <80);
方法二:
先按名字分组,再在分组中直接查出每门课程的成绩大于等于80的同学的名字
select name from student
group by name
having min(score)>=80;
参考文章 :http://blog.csdn.net/liuchunming033/article/details/47279003