SQL random query includes (sqlserver,mysql,access etc) _ database Other

SQL Server:
SQL code

Copy Code code as follows:

Select Top N * out TABLE ORDER by NewID ()

The NewID () function creates a unique value for the uniqueidentifier type. The above statement implementation effect is to randomly read n records from the table.
Access:
SQL code

Copy Code code as follows:

Select Top N * "from" TABLE Order by Rnd (ID)

Rnd (ID) where the ID is an AutoNumber field, you can use any number of other values to complete, such as using the last name segment (UserName)
SQL code

Copy Code code as follows:

Select Top N * from TABLE ORDER by Rnd (Len (UserName))

Mysql:
SQL code

Copy Code code as follows:

Select * from TABLE ORDER by Rand () Limit 10

PostgreSQL
SQL code

Copy Code code as follows:

SELECT * from glxt022 order by random () limit 5