Abstract: A SQL based algorithm to abstract random record set from database is proposed in this paper. To reject the consistently used method which brings about the stochastic process by use of programming at client,the algorithm combines the pseudo-random functions and inverted functions,so it can processes the stochastic process only by one SQL statement.The algorithm is simple,efficiently and costless, so it is very useful.

摘要： 本文提出了一种基于SQL语句的从数据库中随机读取随机记录集合的算法。该算法摒弃了贯用的通过复杂的客户端编程实现随机过程的做法，通过对SQL语言中的伪随机函数和反转函数进行组合，只用一条SQL语句就可以实现随机过程，算法实现简单，资源占有率低，效率高，具有很强的通用性和实用性。