access方法 intRandomNumber是个随机数string sql = "select top 10 Title,objectGuid from Document Order By Rnd(" + (-1 * intRandomNumber) + "*id)";
楼上的这种效率很低。 可分两步,先查总记录数,再按照每页一条记录分页。 MySQL+php $count = select count(*) as c from table where ...; $rand = rand(1,$count['c']); $sql = select * from table where ... limit $rand,1;
intRandomNumber是个随机数string sql = "select top 10 Title,objectGuid from Document Order By Rnd(" + (-1 * intRandomNumber) + "*id)";
可分两步,先查总记录数,再按照每页一条记录分页。
MySQL+php
$count = select count(*) as c from table where ...;
$rand = rand(1,$count['c']);
$sql = select * from table where ... limit $rand,1;