access数据库这样写:
Randomize
sq="select top 5 * from text1 order by rnd(-(id+" & rnd() & "))"
select top 10 * from table order by rnd(id)
select top 10 * from table order by rnd(id-timer())
mssql数据库这样写:
sql="select top 5 * from text1 order by newid()"
Randomize
sq="select top 5 * from text1 order by rnd(-(id+" & rnd() & "))"
select top 10 * from table order by rnd(id)
select top 10 * from table order by rnd(id-timer())
mssql数据库这样写:
sql="select top 5 * from text1 order by newid()"