Y12XJ的博客

1. group by 分组 取最大值 过程： 先分组取出最大值的字段作为一张临时表，在原表相关联。 select a.* from test a inner join (select name,max(score) score from test group by name)b on a.name=b.name and a.score=b.score order by a.name; ...