在网上找到的这个,留着以后用的着! Sql代码 select top 每页显示的记录数 * from topic where id not in (select top (当前的页数-1)×每页显示的记录数 id from topic order by id desc) order by id desc 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,所以如果数据只有一页的话就得做判断了。。 SQL2005中的分页代码: Sql代码 with temptbl as ( SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row, ... ) SELECT * FROM temptbl where Row between @startIndex and @endIndex