还是筛选相同记录

[小妮妮儿]

SELECT TOP 10 id,which,sh,tt,dtime FROM table WHERE (type='resource') AND (tj=1) AND (sh=1) ORDER BY dtime DESC

我现在选出排在表 table 中前10条记录. 但是发现 tt (标题)这10条记录中有重复的记录.

怎么加筛选语句筛掉 tt 相同的记录(tt要保留一条)

id (自增型int,不会重复,主键).

[wgsasd311]

SELECT TOP 10 id,which,sh,tt,dtime FROM tb a
WHERE (type='resource') AND (tj=1) AND (sh=1)
and not exists(select 1 from tb where tt=a.tt and id<a.id)
ORDER BY dtime DESC

[longcyj]

group by tt

[bugchen888]

wgsasd311(自强不息) 正解。

[dyit1325]

学习，wgsasd311正确。