Shulou(Shulou.com)05/31 Report--

This article shows you how to use SQL sentences to achieve access random display of 10 pieces of data, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

The code is as follows:

Select * from table order by rnd (id)

Where id in rnd (id) is the self-growing field in the table

Access random display records (do not repeat) solution

The copy code is as follows:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.