查询以从MS Access中检索随机记录 [英] Query for retrieving random records from MS Access

问题描述

可能重复:
如何从MS Access数据库获取随机记录

Possible Duplicate:
How to get random record from MS Access database

在我的项目中，我经历了一个场景，在该场景中，我必须从MS Access表中随机检索记录.我应该使用哪种查询来随机检索记录?

In my project I have gone through a scenario, where i have to retrieve records from MS Access table RANDOMLY. What query should I use to retrieve the records in a random base??

推荐答案

假定表MyTable中的主键ID字段为自动递增整数，则可以执行以下操作来检索，例如说MyTable中的10条随机记录:

Assuming that in a table MyTable you have a primary key ID field in a that is an autoincrement integer, you can do something like this to retrieve, say 10 random records from MyTable:

SELECT Top 10 *
FROM   (SELECT *,
           Rnd(ID) AS RandomValue
        FROM   MyTable)
ORDER  BY RandomValue 

修改:
找到了另一个类似的答案:如何从MS Access数据库获取随机记录

Found another similar answer: How to get random record from MS Access database

这篇关于查询以从MS Access中检索随机记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！