数据库查询排序使用随机排序结果示例(Oracle/My

select from table1 order by dbms_random.value();

-- 狼蚁网站SEO优化的查询语句效率高，不要使用 SELECT FROM table1 ORDER BY rand() LIMIT 1 来查询 SELECT FROM table1 WHERE id=(SELECT id FROM table1 ORDER BY rand() LIMIT 1)

SELECT FROM table1 ORDER BY rand()

SELECT
　　FROM Northwind Orders
　　ORDER BY NEWID()

SELECT TOP 10
　　FROM Northwind Orders
　　ORDER BY NEWID()