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

This article mainly introduces "what are SQL random queries". In daily operation, I believe many people have doubts about SQL random queries. Xiaobian consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "what are SQL random queries?" Next, please follow the editor to study!

SQL Server:

Sql code

The copy code is as follows:

Select TOP N * From TABLE Order By NewID ()

The NewID () function creates a unique value of type uniqueidentifier. The above statement has the effect of randomly reading N records from Table.

Access:

Sql code

The copy code is as follows:

Select TOP N * From TABLE Order By Rnd (ID)

The ID in Rnd (ID) is an automatic numbering field, which can be done with any other numeric value, such as the name field (UserName).

Sql code

The copy code is as follows:

Select TOP N * From TABLE Order BY Rnd (Len (UserName))

MySql:

Sql code

The copy code is as follows:

Select * From TABLE Order By Rand () Limit 10

PostgreSQL

Sql code

The copy code is as follows:

Select * from glxt022 order by random () limit 5

At this point, the study of "what is the random query of SQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.