求一个SQL语句

表A结构及数据示例如下：

NAME    TIME1        TIME2
---------------------------------
TOM    2009-01-01    2009-01-02
JACK    2010-01-01    2010-02-03
TOM    2009-01-01    2009-07-02
TOM    2009-01-01    2009-12-02
TOM    2009-01-01    2009-02-05
JACK    2010-01-01    2010-02-10
BEN    2009-12-15    2010-02-03

希望选出每个NAME值TIME2列最新的数据，即选出：
TOM    2009-01-01    2009-02-05
JACK    2010-01-01    2010-02-10
BEN    2009-12-15    2010-02-03

多谢啦。

---

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

---

select * from t t1
where not exists (
select 1 from t t2
where t1.name = t2.name and t1.time2 < t2.time2);

---

不要time1的信息，可以直接用group by,也可以

select * from t t1
where (t1.name, t1.time2) in
(
select name, max(time2) from t group by name
);

---

没有主键,楼主这个不好弄哦

---

select * from tb a
where not exists(select 1 from tb b
where a.name=b.name and a.time2 <b.time2)

---

select a.* from tb a