查询数据库中第6条到第10条信息的代码怎么写的?

do where not rs.eof and 6<=t<=10
......
rs.movenext
t=t+1
loop

do where not rs.eof and 6<=t<=10
......
rs.movenext
t=t+1
loop

是对的

select top 6 * from (select top 9 * from table order by id) table order by id desc

do where not rs.eof and 6<=t<=10
......
rs.movenext
t=t+1
loop
支持

select * from (select menu_id,ROW_NUMBER() over (order by menu_id) rn from tab_menu) where rn between 6 and 10