如何选出倒序的第二条记录

[sunshine_anycall]

RT

[liangCK]

按id排序.

select top 1 * from tb as a
where id < (select max(id) from tb)
order by id desc;


--2005使用row_number() over()

select *
from(select rowid=row_number() over(order by id desc),* from tb) as a
where rowid=2

[xierme_sun]

1楼正解

[黄_瓜]

select top 1 * from(select top 2 * from [tb] order by id desc) t order by id

[黄_瓜]

--2005
select * from
(
  select rowid=row_number() over(order by id desc),* from tb
) as t
where rowid=2

[hao1hao2hao3]

取n到m行

select top m * from tablename where id not in (select top n id from tablename order by id asc/*|desc*/) 

[sunshine_anycall]

问题搞定谢谢各位哦！