select IDENTITY(int,1,1) as iid,* into #temptable from yourtable
select top 1 * from #temptable where iid=NOR:select top 1 * from yourTable where id not in(select top N-1 id from table)
ID为表具有唯一值的任何字段
select top 1 * from #temptable where iid=NOR:select top 1 * from yourTable where id not in(select top N-1 id from table)
ID为表具有唯一值的任何字段
ID为表具有唯一值的任何字段试过不行。
有什么办法不用零时表就能实现。
...
rs.move N