mysql: select * from tablename order by rand() limit 10 sqlserver: select top 10 * from tablename order by NEWID()
Sqlite：Select * From tablename order by random(*) limit 10
Oracle：
SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum <= 10
PostgreSQL：
SELECT column FROM table ORDER BY RANDOM() LIMIT 10
转载于:https://www.cnblogs.com/bennylam/archive/2010/05/18/1738387.html
相关资源：mongodb 随机获取一条记录的方法