面试之——查询所有分数大于80的人

mysql> select name from test group by name having min(code)>80;
查询分数大于80的所有人

查询分数大于80的所有人及相关信息
mysql> select *from test where name in (
-> select name from test group by name having min(code)>80);