SqlServer 分頁查詢

標籤：

1.not in方法select top 10 from books where id not in(select top 30 id from books) 2.row_number()函數select * from (select *,row_number() over (order by id) numfrom books) a where num between 31 and 40 3.預存程序分頁create proc proc_AdminPages@pageIndex int,--當前頁碼@pageSize int--每頁數量asdeclare @begin int,@end int--定義局部變數set @[email protected]*(@pageIndex-1)+1--賦值set @[email protected]*@pageIndexselect * from (select ROW_NUMBER() over(order by id) as RowIndex,* from Admin) awhere RowIndex between @begin and @end --執行exec proc_AdminPages 2,1

SqlServer 分頁查詢