获取分组后取某字段最大一条记录

获取分组后取某字段最大一条记录
方法一：(效率最高)
select * from test as a 
where typeindex = (select max(b.typeindex) 
from test as b 
where a.type = b.type );