随机读取几条文章的sql写法

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()"
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页