SQL分页语句

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

需要注意的是在access中不能是top 0，所以如果数据只有一页的话就得做判断了。。

2：SQL2005中的分页代码

模板:

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

示例：

with temptbl as (  
  SELECT ROW_NUMBER() OVER (ORDER BY CustomerID desc)AS 行号,* from Customers   
)  
SELECT * FROM temptbl where 行号 between 1 and 10

引用：http://niunan.javaeye.com/blog/264197