==================取第5个:
declare cursor_insert scroll cursor for select * from 你的表
open cursor_insert
fetch ABSOLUTE 5 from cursor_insert
close cursor_insert
deallocate cursor_insert
declare cursor_insert scroll cursor for select * from 你的表
open cursor_insert
fetch ABSOLUTE 5 from cursor_insert
close cursor_insert
deallocate cursor_insert
select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表select * from #temp where ID_Num =2drop table #temp