饹炸饸怎么读:查询数据库中第6条到第10条信息的代码怎么写的?
来源:百度文库 编辑:高考问答 时间:2024/05/22 00:46:23
查询数据库中第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