查询数据库中的第100条数据

select identity(int,1,1) as iid,* into #tmp from 表

select * from #tmp where iid = 100

drop table #tmp

转载于:https://www.cnblogs.com/zndavid/archive/2004/09/02/38840.html