sql 不重复记录问题

来源：百度知道 编辑：UC知道 时间：2024/05/31 00:07:04
求sql语句一条

id title datetime

41 aaaaaa 2008-9-17 17:14:43
43 bbbbbb 2008-9-19 16:10:08
43 cccccc 2008-9-20 19:18:33
44 dddddd 2008-9-20 21:18:04
44 eeeeee 2008-9-21 17:34:35
45 ffffff 2008-9-21 19:22:13
44 eeeeee 2008-9-22 21:53:29

按datetime排序，列出不重复id，
结果如下：
44 eeeeee 2008-9-22 21:53:29
45 ffffff 2008-9-21 09:22:13
43 cccccc 2008-9-20 19:18:33
41 aaaaaa 2008-9-17 17:14:43
一楼的运行不了，其它的都没解决问题，再等高手！~

select a.* from T1 a,
(select id,max(datetime) as datetime from T1
group by id) b
where a.id=b.id and a.datetime=b.datetime
order by a.datetime desc

试一下

select distinct id
from 表名
order by [datetime] desc

这么简单?

select distinct(id),title,datetime from table order by datetime desc;

select distinct * from 表名 order by datetime desc