SQL 的分页

with temptbl as (          -----临时表名  
  SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row, * from  表名   
  ...   
)   
SELECT * FROM temptbl where Row between @startIndex and @endIndex  

select top 每页显示的记录数 * from topic where id not in  
 (select top （当前的页数-1）×每页显示的记录数 id from topic order by id desc)   
 order by id desc