SQL random Query Data statement (NewID (), Rnd,rand (), Random ())

SQL Server:

Code to copy code as follows
Select TOP N * from TABLE Order by NewID ()

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

Access:

Code to copy code as follows
Select TOP N * from TABLE Order by Rnd (ID)

Rnd (ID) where the ID is an AutoNumber field that can be done with any other value, such as using the Name field (UserName)

Se (www.111cn.net) lect TOP N * from TABLE Order by Rnd (Len (UserName))

Mysql:

Code to copy code as follows
Select * from TABLE Order by Rand () Limit 10

PostgreSQL:

Code to copy code as follows
SELECT * from glxt022 order by random () limit 5

Summary: The above methods I was in the order by behind the instance, only MSSQL used top this is its language database server restrictions.
From:http://www.111cn.net/database/mssqlserver/42764.htm

SQL random Query Data statement (NewID (), Rnd,rand (), Random ())