手机上怎么用话费充q币:查询数据库中第6条到第10条信息的代码怎么写的?
来源:百度文库 编辑:查人人中国名人网 时间:2024/10/06 20:37:21
查询数据库中第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