就是找第98行了:
如果有ID:
select top 1 * from t1 where id not in (select top 97 id from t1)
如果没有ID:
select top 98 *,identity(int,1,1) into #temp from t1
select top 1 * from #temp order by id desc
drop table #temp
也可借用其它有序的field
如果有ID:
select top 1 * from t1 where id not in (select top 97 id from t1)
如果没有ID:
select top 98 *,identity(int,1,1) into #temp from t1
select top 1 * from #temp order by id desc
drop table #temp
也可借用其它有序的field
那第一条就是你要的纪录。
(select top 98 * from yourtable order by somefield) t1
order by somefield desc
你不说是用什么索引的话序号就只有物理顺序
这个是无法实现的!!去看看关系数据库的书吧!