求一条sql语句 （论坛信息表那个续，提供数据脚本）

[jianjialin]

[Code=SQL]

declare @message table(
messageid int identity(1,1) primary key,
topicid int,--外键 主题表ID
Replyto int,--外键 userid(就是帖子发出人的ID。 如果是发帖 ，那么这为NULL； 如果是跟帖， 则为发帖者的ID)
userid int, --本条信息发出者（跟帖者ID 或者发帖者ID）
posted datetime--发布时间
)
[/Code]


想求当前用户的回复过的帖子的主题ID(topicid)
按posted desc排序
我的答案是

[Code=SQL]

select topicid from @message where Userid='当前用户ID' and Replyto is not null --Replayto isnotnull则表示我回帖
order by posted desc
[/Code]


得到当前用户回过贴的 帖子 的id（topicid）

但是，一个帖子可以回复很多次，因此，topicid会重复。
我想要一个不重复我结果。 但是试了好多次，不成功。


脚本地址
http://62.dc.ftn.qq.com/ftn_handler/84424247426e8de726f07e996fb7fbe67cfe997760c8a4673c41ed6e9938878243d0669ced5b190c058e3fb25c324014ff8630ba5225fc302cbea3500fd1a870/1.sql?k=58393636cbfac6c7052d713640660b17585a010455000f0a4c080152044b0d0e05001b0f56565d150308045057070e5d03580e55666339094f4a475a66

[jianjialin]

地址粘贴在IE上即可
提取码 a966ff98

QQ的文件中转 ， 无毒放心

[jianjialin]

declare @message TABLE (
[MessageID] [int] NOT NULL,
[TopicID] [int] NOT NULL,
[ReplyTo] [int] NULL,
[Position] [int] NOT NULL,
[Indent] [int] NOT NULL,
[UserID] [int] NOT NULL,
[UserName] [nvarchar] (50) NULL,
[Posted] [datetime] NULL,
[Message] [ntext] NOT NULL,
[IP] [nvarchar] (15) NOT NULL,
[Edited] [datetime] NULL,
[Flags] [int] NOT NULL DEFAULT ((23)),
[AnswerQuestionPoint] [int] NULL DEFAULT ((0)))

INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 57,20,0,0,2,'2009-5-26 9:31:46','test','127.0.0.1',30,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 58,21,0,0,14,'2009-5-27 15:02:13','nntpservernntpservernntpservernntpservernntpservernntpserver','127.0.0.1',30,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 59,20,57,1,1,14,'2009-5-27 16:29:44','范德萨范德萨','127.0.0.1',30,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 60,22,0,0,2,'2009-5-27 17:07:38','是的范德萨放大放大时','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 61,23,0,0,2,'2009-5-27 17:08:24','防范方法防范','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Edited],[Flags],[AnswerQuestionPoint]) VALUES ( 62,24,0,0,2,'2009-5-31 11:27:40','o:) =; ](*,) ](*,) ](*,) ](*,) ](*,) ](*,) 端午归来第一天端午归来第一天端午归来第一天','127.0.0.1','2009-6-11 16:18:41',21,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Edited],[Flags],[AnswerQuestionPoint]) VALUES ( 63,24,62,1,1,2,'2009-5-31 11:38:20','专业回复今天是周日','127.0.0.1','2009-5-31 15:54:24',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 64,23,61,1,1,2,'2009-5-31 15:48:55','fdsafff','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 65,22,60,1,1,77,'2009-6-4 9:33:17','123123','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 66,22,60,2,1,77,'2009-6-4 9:44:55','drdddddddd','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 67,25,0,0,19,'2009-6-4 16:52:23','今天星期几','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 68,26,0,0,19,'2009-6-4 16:53:21','石狮市ffffff','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 69,26,68,1,1,19,'2009-6-4 17:33:38','防范方法防范方法防范放','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 70,27,0,0,2,'2009-6-5 9:00:06','新帖错误休闲鞋','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 71,26,68,2,1,19,'2009-6-5 10:25:32','回个帖看看','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 72,26,68,3,1,77,'2009-6-8 11:36:26','爆发了相应在','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 73,26,68,4,1,70,'2009-6-8 11:39:38','我也来回复1','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 74,26,68,5,1,70,'2009-6-8 11:40:06','我也来回复2','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 75,26,68,6,1,2,'2009-6-8 11:41:22','gliyuan','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 76,25,67,1,1,2,'2009-6-9 19:09:54','管理员回复','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 77,28,0,0,19,'2009-6-10 15:03:14','测试一下最新的提问测试一下最新的提问测试一下最新的提问','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 78,28,77,1,1,19,'2009-6-10 15:03:33','回答一下放大法','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 79,28,77,2,1,2,'2009-6-10 15:03:58','范德萨范德萨放','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 80,29,0,0,19,'2009-6-10 15:15:08','zhensan zhensan','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[ReplyTo],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 81,29,80,1,1,2,'2009-6-10 15:16:06','fdsafdsfdsa','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 82,30,0,0,19,'2009-6-10 15:28:11','fffffffffffffffff','127.0.0.1',22,0)
INSERT @message ([MessageID],[TopicID],[Position],[Indent],[UserID],[Posted],[Message],[IP],[Flags],[AnswerQuestionPoint]) VALUES ( 83,31,0,0,19,'2009-6-10 15:47:59','yyyyyyyyyyy','127.0.0.1',22,0)


select * from @message

[jianjialin]

假设当前用户ID为2

求他回复过的帖子列表， 按回帖时间降序排列