Oracle查询结果集,随机排序
select * from test order by dbms_random.value()
MySQL随机查询出一条记录:
SELECT * FROM test ORDER BY rand()
MS SQL Server 随机查询出一条记录:
SELECT TOP 10 * FROM test ORDER BY NEWID()
Oracle查询结果集,随机排序
select * from test order by dbms_random.value()
SELECT * FROM test ORDER BY rand()
SELECT TOP 10 * FROM test ORDER BY NEWID()