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
原文：http://blog.csdn.net/u013011841/article/details/39290587