34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT id,videoid,ip,author,loginname,[content],dateadded,display,replyto FROM
(SELECT ROW_NUMBER() OVER (ORDER BY DateAdded DESC) AS [ROW_NUMBER], id,videoid,ip,author,loginname,[content],dateadded,display,replyto
FROM [Comments] where videoid=19 and display=1 and replyto=0)
AS [t1] WHERE [t1].[ROW_NUMBER] BETWEEN 11 and 21