摘要： 选择表的前10条:select top 10 * from 表 order by 需要排序的字段选择表的11-20条:select * from (select row_number() over (order by 需要排序的字段) as id,* from 表)awhere id between 11 and 20或者select top 10 * from 表where id not in (select top 10 * from 表 order by 需要排序的字段)order by 需要排序的字段topn方式的分页存储过程：alter PROCEDURE sp_GetPageOfR 阅读全文