摘要： # 获取分组后取某字段最大一条记录 # 方法一：(效率最高) select * from test as a where typeindex = (select max(b.typeindex) from test as b where a.type = b.type ); # 方法二：(效率次之) 阅读全文