求一条SQL语句写法？

[漫天飞舞时]

1
id timedate
3 2008-10-12
3 2009-10-12
3 2006-10-12
4 2005-12-13
4 2005-12-12
5 2007-12-23
6 2006-12-23
6 2006-01-23

一句话SQL在ORACLE查询出同相同ID时间最大的行
结果
3 2009-10-12
4 2005-12-13
5 2007-12-13
6 2006-01-23


那位牛人给想想办法。。。。

[小灰狼W]

select id,max(timedate) from tt
group by id
就行了吧？

[liusong_china]

SELECT id,MAX(timedate) timedate FROM tb GROUP BY id ORDER BY id;