Order by newid () random Query

SQL Server:

Select Top N * from Table order by newid ()
View plaincopy to clipboardprint?
Select Top N * from Table order by newid ()

Select Top N * from Table order by newid ()
The newid () function creates a unique value of the uniqueidentifier type. The preceding statement reads N records randomly from the table.

Access:

Select Top N * from Table order by RND (ID)
View plaincopy to clipboardprint?
Select Top N * from Table order by RND (ID)

Select Top N * from Table order by RND (ID)
In RND (ID), the ID is an automatic number field, which can be completed using any other value, for example, the name field (username)

Select Top N * from Table order by RND (LEN (username ))
View plaincopy to clipboardprint?
Select Top N * from Table order by RND (LEN (username ))

Select Top N * from Table order by RND (LEN (username ))

MySQL:

Select * from Table order by rand () limit 10
View plaincopy to clipboardprint?
Select * from Table order by rand () limit 10

Select * from Table order by rand () limit 10

PostgreSQL:

Select * From glxt022 order by random () limit 5
View plaincopy to clipboardprint?
Select * From glxt022 order by random () limit 5