ASP中读出第二条到第十条。ASP查询语句怎么写？

1直接：select top 9 * from forum where id <(select max(id) from forum) order by id Desc
方法2 ：
select * from (select top 9 * from (select top 10 * from forum order by id desc) as t order by id asc) as p order by id desc

读前10条出来！！

显示的时候设置下！加个判断，前两条不显示！！！！！

好像行，以前见过不过忘了。不知道我的笨思想对不对。读出了前10条。再在这10条中倒序读9。嘻。

set rs=server.creatobject("adodb.recordset")
sql="select top 10 * from forum by id Desc"
rs.open sql,conn,1,1
do while not rs.eof
a=rs("a")
b=rs("b")
response.write a
response.write b
loop
rs.close
set rs=nothing