asp.net_asp 随机读取N条记录sql语句

更新时间:2016-04-26    来源:Dom教程    手机版     字体:

【www.bbyears.com--Dom教程】

<%
randomize
sql="select top 10 name,time,id,url,filename from art_body where ischeck=1 order by rnd(-(id+"&rnd()&")),time desc"
......
%>

本文来源:http://www.bbyears.com/wangyezhizuo/23438.html

猜你感兴趣