select top 10 ...,我要从第2条记录开始显示，如何？？？？

[xfxq]

select top 10 * from news
取出10条记录，现我想从第2条记录开始显示，共9条记录，第一条不要，如何写代码，谢谢。急！

[serverme]

这样写我试了好用的,有问题联系我:MSN:[e-mail]
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn/conn1.asp"-->
<%
dim i
Set rs=Server.CreateObject("ADODB.Recordset")
Sql="select * from employee"
rs.open sql,conn,1,1

while not rs.eof
if i=0 then
rs.movenext
end if
response.write(rs("emp_id")&"<br>")
i=i+1
rs.movenext
wend
%>

[serverme]

<%
dim i
Set rs=Server.CreateObject("ADODB.Recordset")
Sql="select top 10 * from news"
rs.open sql,conn,1,1

while not rs.eof
if i=0 then
rs.movenext
end if
response.write(rs("字段名")&"<br>")
i=i+1
rs.movenext
wend
%>

[aspczlover]

'读取第n到m条记录
sql="SELECT TOP m-n+1 * FROM publish WHERE (id NOT IN (SELECT TOP n-1 id FROM publish)) "
'你这里的m=10，n=2，也就是
sql="SELECT TOP 9 * FROM news WHERE (id NOT IN (SELECT TOP 1 id FROM news))"

[fashchina]

先移一个记录就是
select top 10 * from news
rs.open sql,conn,1,3
rs.movenext
不知道行不行

[xfxq]

试过了,好像是可以的.谢谢.

[sinusoid]

select top 9 * from news where id not in(select top 1 id from news)

[dafeifei]

晕！

[dsclub]

rs.move(2)