order by newid() 各种数据库随机查询的方法
时间:2024-01-19 16:53:14
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()
NewID()函数将创建一个 uniqueidentifier 类型的唯一值。上面的语句实现效果是从Table中随机读取N条记录。
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)
Rnd(ID) 其中的ID是自动编号字段,可以利用其他任何数值来完成,比如用姓名字段(UserName)
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))
MySql:
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
标签:数据库,随机查询
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
SQL提取数据库表名及字段名等信息代码示例
2024-01-26 23:18:54
python判断一个数是否能被另一个整数整除的实例
2021-02-06 13:25:42
Python 使用PIL numpy 实现拼接图片的示例
2021-03-20 02:50:20
Linux下如何实现Mysql定时任务
2024-01-19 09:41:50
python 两个数据库postgresql对比
2024-01-22 16:29:36
Pytorch.nn.conv2d 过程验证方式(单,多通道卷积过程)
2021-12-24 13:28:27
![](https://img.aspxhome.com/file/2023/0/97720_0s.jpg)
Python3中安装后SSL问题及解决
2022-07-04 14:41:16
![](https://img.aspxhome.com/file/2023/5/123525_0s.jpg)
php中如何判断一个网页请求是ajax请求还是普通请求
2023-10-13 14:42:30
python爬虫中抓取指数的实例讲解
2022-02-18 04:59:58
![](https://img.aspxhome.com/file/2023/4/101564_0s.png)
Python descriptor(描述符)的实现
2021-12-22 09:07:56
![](https://img.aspxhome.com/file/2023/0/90400_0s.png)
asp如何在数据库中用好Transaction?
2010-06-22 21:07:00
Keras目标检测mtcnn facenet搭建人脸识别平台
2023-09-28 07:02:01
![](https://img.aspxhome.com/file/2023/8/90838_0s.png)
linux下利用Docker安装mysql的步骤
2024-01-25 01:17:56
JAVA及PYTHON质数计算代码对比解析
2023-08-29 23:41:31
Golang中异常处理机制详解
2024-02-17 17:05:50
![](https://img.aspxhome.com/file/2023/3/107303_0s.png)
浅谈Pycharm调用同级目录下的py脚本bug
2023-09-12 15:39:27
![](https://img.aspxhome.com/file/2023/8/97728_0s.jpg)
Python队列RabbitMQ 使用方法实例记录
2021-01-30 22:38:26
![](https://img.aspxhome.com/file/2023/3/83753_0s.png)
pandas 数据索引与选取的实现方法
2021-07-09 17:37:44
SQL语句之WHERE子句的使用方法
2007-08-11 12:25:00
Safari显示网页字体为超级无敌难看的宋体的原因
2008-04-20 16:49:00