Oracle：

select * from (select * from table_name order by dbms_random.random()) where rownum <=10

MySQL：

SELECT * FROM TABLE_NAME  ORDER BY  RAND() LIMIT 10

ThinkPHP：
Db::table('table_name')->orderRaw("RAND()")->limit(10)->select();

SQL Server：

SELECT TOP 10 * FROM TABLE_NAME ORDER BY NEWID()