mysql查询--35分

mysql 中一个表中字段如下: id  value create_time 三个字段
如数据有: 
1  test1  2009-9-10
1  test2  2009-9-11
2  testg  2009-9-10
3  testu  2009-9-11
3  testn  2009-9-10
我要想得到的结果是当id相同时，只取create_time为最大的一条数据，这样取得结果会是
1  test2  2009-9-11
2  testg  2009-9-10
3  testu  2009-9-11
请问这个sql语句应该怎么写?

谁先给出正确语句，分全给他......急用中

---

帮到你顶下。。呵呵。

---

SQL code:

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断

select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
例二：
select * from testtable
where numeber in (select number from people group by number having count(number) > 1 )
可以查出testtable表中number相同的记录

2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录
delete from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1)

3、查找表中多余的重复记录（多个字段）
select * from vitae a
where (a.peopleId,a.seq) in (sele