sql server 分页/最近查询

sql server 分页/最近查询 (最近3天,0到500条记录,时间和idd倒序)

SELECT t2.rn, t1.* FROM 
dtcontent AS t1 , 
(
SELECT TOP 500 row_number() OVER (ORDER BY DisplayTime DESC, idd DESC) rn, idd 
FROM dtcontent 
where ClassID IN ('C3863', 'C3869', 'C3870', 'C3876') 
and DATEDIFF(dd,DisplayTime,getdate())<3 and DATEDIFF(dd,DisplayTime,getdate())>= 0
) t2 
WHERE t1.idd = t2.idd AND t2.rn > 0 ORDER BY t2.rn ASC