lancer evolution 10:查询数据库中第6条到第10条信息的代码怎么写的?
来源:百度文库 编辑:神马品牌网 时间:2024/04/27 18:04:14
查询数据库中第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