sql 随机获取数据

SQL Server:

SELECT TOP 10 * FROM T_USER ORDER BY NEWID()

MySQL:

SELECT * FROM T_USER  ORDER BY  RAND() LIMIT 10

参考:

posted @ 2020-09-03 20:43  林宇风  阅读(510)  评论(0编辑  收藏  举报