order by newid() 各种数据库随机查询的方法

这篇文章主要为大家详细介绍了order by newid() 各种数据库随机查询的方法，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

SQL Server：

代码如下:

Select TOP N * From TABLE Order By NewID() 
view plaincopy to clipboardprint?
Select TOP N * From TABLE Order By NewID()

Select TOP N * From TABLE Order By NewID()

Access：

代码如下:

Select TOP N * From TABLE Order By Rnd(ID) 
view plaincopy to clipboardprint?
Select TOP N * From TABLE Order By Rnd(ID) 

Select TOP N * From TABLE Order By Rnd(ID)

代码如下:

Select TOP N * From TABLE Order BY Rnd(Len(UserName)) 
view plaincopy to clipboardprint?
Select TOP N * From TABLE Order BY Rnd(Len(UserName))

Select TOP N * From TABLE Order BY Rnd(Len(UserName))

代码如下:

Select * From TABLE Order By Rand() Limit 10 
view plaincopy to clipboardprint?
Select * From TABLE Order By Rand() Limit 10

Select * From TABLE Order By Rand() Limit 10

postgreSQL：

代码如下:

select * from glxt022 order by random() limit 5 
view plaincopy to clipboardprint?
select * from glxt022 order by random() limit 5

注：关于order by newid() 各种数据库随机查询的方法的内容就先介绍到这里，更多相关文章的可以留意