sql id倒序 并从倒数第六个开始排列 在线等

[迎手风雨]

代码：<%
Response.Buffer = True
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "No-Cache"



'得到连接对象
dim conn
dim connstr
on error resume next
set conn=server.createobject("ADODB.CONNECTION")
connstr="DBQ="+server.mappath("/admin888/db.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
conn.open connstr

set rs=server.createobject("adodb.recordset")
sql="select top 2 * from in(select top 5 * from news where class_id=1 order by id desc) order by id desc"
rs.open sql,conn,1,3
do while not rs.eof
%>

<a href="/news/<%=rs("id")%>.html" target="_blank"><%=rs("title")%></a>



<%

rs.movenext
loop

%>
如何修改

[IEEE_China]

看不懂。
这句话什么意思？
“ sql id倒序 并从倒数第六个开始排列 ”

[six-years]

select  ROW_NUMBER() OVER (order by id desc) as row, * from news where id in(select top(select COUNT(*)-6 from news ) id from news )
union all
(select ROW_NUMBER() OVER (order by id asc) as row,* from news where id not in (select top(select COUNT(*)-6 from news ) id from news ))

[發糞塗牆]

倒序，再取倒数第六个开始排序？那不是取不倒序之前的第七个开始排序咯？然后，你的范围是多大？从第七个一直拍下去？

[让你望见影子的墙]

select *
from
(
select px=row_number()over(order by id desc),* from tb
)K
where id>5