急急~大哥！帮我呀！

[liao880]

<%
set rs=server.createobject("adodb.RecordSet")
aa="select * from tp where ty='xp' ORDER BY id desc"
rs.open aa,conn,1,3

%>
我现在想取第三条记录，怎么办呀？

[sinusoid]

rs.move 3

[sunshine5211314]

aa="select top 3 * from tp where id not in (select top 2 id from tp order by id desc ) where ty='xp' ORDER BY id desc"

[newhandtoo]

aa="select top 3 * ..."
rs.open ...
if not rs.eof then
array=rs.getrows()
end if
if isarray(array) then
for i=0 to ubound(array,2)
if i=ubound(array,2) then
response.write "第三条记录"
end if
next
end if

[mao1997]

<%
set rs=server.createobject("adodb.RecordSet")
aa="select top 3 * from tp where ty='xp' ORDER BY id desc"
rs.open aa,conn,1,3
rs.movelast
%>

[sn12345678]

两种方式：
1。 rs.move 2,AdBookmarkFirst
2。（保险一点的方式）
number=3
for i=0 to number-2
if rs.eof = true then exit for
rs.movenext
next