SQL Server:
SELECT TOP 10 * FROM T_USER ORDER BY NEWID()
Oracle:
SELECT * FROM (SELECT * FROM T_USER ORDER BY dbms_random.value) WHERE rownum <= 10
MySQL:
SELECT * FROM T_USER ORDER BY RAND() LIMIT 10
欢迎访问作者个人技术博客:BlackvonCode(www.blackvon.top)
作者的微信公众号和小程序