asp 随机读取N条记录sql语句
发布时间:2015-06-05 来源:查字典编辑
摘要:
<%
randomize
sql="select top 10 name,time,id,url,filename from art_body where ischeck=1 order by rnd(-(id+"&rnd()&")),time desc"
......
%>
<%
randomize
sql="select top 10 name,time,id,url,filename from art_body where ischeck=1 order by rnd(-(id+"&rnd()&")),time desc"
......
%>