![](https://i-blog.csdnimg.cn/blog_migrate/b3dc686433b2c76ae3ae1bf95c2f1c60.png)
答案一:
select name from 表名 group by name having min(fenshu)>80;
答案二:
select name from 表名 group by name having name not in (select name from 表名 where fenshu<80);
答案一:
select name from 表名 group by name having min(fenshu)>80;
答案二:
select name from 表名 group by name having name not in (select name from 表名 where fenshu<80);