--先用row_number()生成序列,再获取 select * from ( select rid=row_number() over (order by 排序字段),* from tb ) t where rid=5
你的要是2000试试用临时表临时表方法:select *,rid=identity(int,1,1) into #tb from tbselect * from #tb where rid = 5如果有按具体的某列排序可以用TOP方法TOP方法:select top 1 * from ( select top 5 * from tb order by col )t order by col desc
--先用row_number()生成序列,再获取
select * from (
select rid=row_number() over (order by 排序字段),* from tb
) t where rid=5
into #tb
from tbselect *
from #tb
where rid = 5如果有按具体的某列排序可以用TOP方法TOP方法:select top 1 *
from (
select top 5 * from tb order by col
)t
order by col desc