SQL SERVER实现基本的分页功能

利用NOT IN 和 SELECT TOP来分页

use WH_WorkshopInforSys
--建立临时表
select IDENTITY(int,1,1) as id,* into mytable
from dbo.PnlBaobiao

-- 分页查询
select top 10 *
from mytable
where id not in (select top 40 id from mytable order by id)
order by id

-- 删除表
drop table mytable