sql 随机获取数据
SQL Server:
SELECT TOP 10 * FROM T_USER ORDER BY NEWID()
MySQL:
SELECT * FROM T_USER ORDER BY RAND() LIMIT 10
参考:
SQL Server:
SELECT TOP 10 * FROM T_USER ORDER BY NEWID()
MySQL:
SELECT * FROM T_USER ORDER BY RAND() LIMIT 10
参考: