如果循环依次取出数据库中的前10条记录？求语句

[lostmoon2000]

如果循环依次取出数据库中的前10条记录？求语句

[纪俊]

rs.open "select top 10 * from [tableName]"
do while not rs.eof
response.write rs("字段名")
rs.movenext
loop

[纪俊]

rs.open "select top 10 * from [tableName] 这里可以加入条件或者规定按照什么进行排序并规定正序或者倒序"

[peijunfeng]

rs.open "select top 10 * from tableName order by 字段名 [desc]"
while not rs.eof
response.write rs("字段名")
rs.movenext
wend
默认好像是降序排列

[jyzxpboy]

同上very easy question

[wfwclyms]

sql="select top 10 * from 表名 order by 字段名 [desc]"

[kevinnewtec]

前面刚刚有人问过,我已经回答了
楼主以后法帖先搜索一下哈
你的点数天掉的呀