1、如果是SQL的话,可以用下面的方式
select top 10 * from table order by newid( )
2、如果是Oracle
select * from ( select * from table order by dbms_random.value ) where rownum <= 10;
3、如果是Access
SELECT top 10 * FROM table ORDER BY Rnd(id)
ID是自增长一个列
4、如果是MySQL
select * from table order by rand() limit 10
希望以上整理能大家有所帮助！
