![四种数据库随机获取N条数据的方法 四种数据库随机获取N条数据的方法](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
1.SQL Server:
SELECT TOP n * FROM tableName ORDER BY NEWID();
2.ORACLE:
SELECT * FROM (SELECT * FROM tableName ORDER BY DBMS_RANDOM.RANDOM()) WHERE RONUM <= n
3.MySQL:
SELECT * FROM tableName ORDER BY RAND() LIMIT n
3.Access:
SELECT TOP n * FROM tableName ORDER BY rnd([一个自动编号字段])
Ps: n 是你要取的条数.O(∩_∩)O~