高效率分页查询语句

 

/**该分页效率最高**/
select top 10 * from Books
where (Id<(select min(Id) from (select top 10 Id from Books order by Id desc) as T))
order by Id desc
--注意as T不能少

/**该分页效率一般**/
select top 10 * from Books where Id not in(select top 20 Id from Books order by Id desc) order by Id desc