sql 语句问题

[zwei3000]

有表table1,有如下字段
id:int
tsid :int
userid:int
docontent:varchar(500)
dodate:datetime
有下列数据
id tsid userid dodate docontent
151 125 222 2009-03-31 11:56:44.653 问题
150 125 333 2009-03-31 11:54:34.123 问题
149 123 444 2009-03-31 11:52:27.403 问题
146 126 555 2009-03-31 11:43:51.543 问题
145 126 666 2009-03-31 11:16:25.250 问题
144 127 777 2009-03-31 11:10:16.140 问题

现在我想获取这样的数据:根据dodate倒序取tsid,并且tsid只取唯一的，如有相同的几项只取一项
就是:select tsid from table1 order by dodate desc 会取出下列的数据
125
125
123
126
126
127
但是我想获得的是下列的数据
125
123
126
127

这个sql语句怎么写呢？

[htl258_Tony]

select distinct tsid from table1 order by dodate desc 

[yangqidong]

select distinct(tsid) from table1 order by dodate desc

[-狙击手-]

select distinct tsid from table1 order by dodate desc

[yangqidong]

select tsid from table1 group by tsid order by dodate desc
也可以

[htl258_Tony]

或者:

select tsid from table1 group by tsid order by dodate desc 

[sdhdy]

select distinct tsid from table1 order by dodate desc

[liangCK]

SELECT *
FROM table1 AS A
WHERE NOT EXISTS(SELECT * FROM table1 WHERE tsid=A.tsid AND dodate>A.todate);

[dj3688]

select tsid from table1 group by tsid order by dodate desc

[zwei3000]

我需要按照dodate倒序的,唯一的tsid列表

select distinct tsid from table1 order by dodate desc 这样是有语法错误的

SELECT *
FROM table1 AS A
WHERE NOT EXISTS(SELECT * FROM table1 WHERE tsid=A.tsid AND dodate>A.todate) 这句可以获取唯一的，但是不能按照dodate倒序排列

[sdhdy]

SELECT * 
FROM table1 AS A 

WHERE NOT EXISTS(SELECT * FROM table1 WHERE tsid=A.tsid AND dodate>A.todate) order by dodate desc

[lzfrab]

没明白..

[usher_gml]

select distinct tsid from table1 order by dodate desc

[zwei3000]

谢谢 sdhdy，搞定

[zwei3000]

谢谢 sdhdy，搞定