Examples of randomly extracting 10 records:
Sqlserver:
selecttop10*from table orderbynewid()
Access:
Selecttop10*FROM table orDERBYRnd(id)
Rnd(id) where id is an automatic numbering field, which can be completed using any other numerical value.
For example, use name field (UserName)
Selecttop10*FROM table orDERBYRnd(len(UserName))
MySql:
Select*From table orderByrand()Limit10