sql分頁查詢

insert into Info select \'admin36\' from Info; --FK插入法

select COUNT(*) from Info;

--not in 實作分頁查詢

declare @pageSize int set @pageSize= 10;--行數

declare @pageNo int set @pageNo = 1000;--頁數

select top(10) * from Info

where id not in (

 select top(@pageSize*(@pageNo-1)) id from Info

) 

-- 使用大于号 > 實作分頁查詢

declare @pageSize int set @pageSize= 10; --行數

declare @pageNo int set @pageNo = 1000;  --頁數

select top(@pageSize) * from Info where id >

(select max(id) from           --取前十條資料的最大值

(select top(@pageSize*(@pageNo-1)) id from Info) as empInfo)   --查詢前十條資料

--使用 row_num between 實作分頁查詢

select * from

(select ROW_NUMBER() over(order by id) as no,* from Info) as emp

where emp.no between 100 and 110