SQL-----group by 查询多个字段

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

按name分组