select * from test as a where a.dateCreated = (select max(dateCreated) from test as b where a.name=b.name) 按name分组