Extract 10 records of records: SQL Server:
SELECT
TOP
10
*
From
table
ORDER
BY
NewID
() Access:
SELECT
TOP
10
*
From
table
ORDER
BY
RND (ID) RND (ID) The ID is the automatic number field, you can use any other value to complete, such as using the Name Field (Username)
SELECT
TOP
10
*
From
table
ORDER
BY
RND
Len
(UserName)) MySQL:
SELECT
*
From
table
ORDER
BY
Rand
() LIMIT
10
