如何从 MS Access 数据库中获取随机记录 [英] How to get random record from MS Access database

问题描述

我有一个 MS Access 数据库.其中，一张表由带有主键 questionID 的问题和答案组成.我需要使用 questionID 从该表中检索随机问题.对于这种情况，我应该使用哪些关键字或查询.

I have a MS access database. In that, one table consists of questions and answers with primary key questionID. I need to retrieve random question from that table using questionID. What keywords or query should I use for this scenario.

推荐答案

以下将从您的表中随机获取一个 questionID

The following will get a random questionID from your table

MySQL

SELECT questionID FROM questions ORDER BY RAND() LIMIT 1

MS 访问

SELECT top 1 questionID from questions ORDER BY rnd(questionID)

这篇关于如何从 MS Access 数据库中获取随机记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！