SQL group by 取最新一条数据

如现有数据：

id | name | time

1 | aaa | 1566204958
2 | aaa | 1566204967
3 | aaa | 1566204989
4 | bbb | 1566204958
5 | bbb | 1566204967
6 | bbb | 1566204989
7 | ccc | 1566204958
8 | ccc | 1566204967
9 | ccc | 1566204989

现需要根据 name 获取 name 对应的最新的记录，即应该得到结果是：

id | name | time

3 | aaa | 1566204989
6 | bbb | 1566204989
9 | ccc | 1566204989

SQL 可以这样写：

select name,max(time) as time from test group by name

更通用的方法可以这样写：

select * from test as log where log.time= (select max(time) from test as q where q.name = log.name) group by log.name;

这样就可以group by获取最新时间的一条记录