神马品牌网壶关县石坡地图:ASP查询数据库问题
来源：百度文库 编辑：神马品牌网 时间：2024/04/26 01:52:29
怎么查询排行2-10
例如查询
sql="SELECT top 12 *FROM user order by id desc"
怎么查询除掉前2个只查询top2-top10
谢谢
例如查询
sql="SELECT top 12 *FROM user order by id desc"
怎么查询除掉前2个只查询top2-top10
谢谢
sql="SELECT top 12 *FROM user order by id desc"
for i=1 to rs.recordsetcount
if i=1 or i=1 then
rs.movenext
i=i+1
else
rs("XX")
i=i+1
rs.movenext
end if
next
select top10 from (SELECT top 12 *FROM user order by id desc) by id
试一试这样，不敢保证，其实方法很多
楼上稍微有点错误，应该是
sql="SELECT top 12 *FROM user order by id desc"
for i=1 to rs.recordsetcount
if i=1 or i=2 then
rs.movenext
i=i+1
else
response.write rs("XX")
i=i+1
rs.movenext
end if
next