如何取一个表的分组中时间最晚的一条记录？(oracle)

环境：oracle 9i
表名：table

name                        time

mike                        20100209-00:10:01:123
mike                        20100209-00:02:01:234
mike                        20100208-09:02:05:564


想得到结果：

name                        time

mike                        20100209-00:10:01:123

请教各位　查询语句应该如何写？

---

SQL code:

SELECT NAME,TIME
from table
WHERE (NAME,TIME) EXISTS
(SELECT NAME,MAX(TIME) from table GROUP BY NAME)

---

select name,max(time) from table group by name

---

select name,time from
  (select row_number () over ( partition by name order by time desc) rn,t.name,t.time from table t)
where rn=1;

---

select name,time from
  (select row_number () over ( partition by name order by time desc) rn,t.name,t.time from table t)
where rn=1;

---

SQL code

---

Code highlighti