Database query sorting using random sort results example of Oracle and MySQL and MS SQL Server

Oracle query result set, randomly sorted

select * from table1 order by dbms_random.value();

MySQL randomly queries 1 record:

 
--  The following query statement is efficient, so don't use  SELECT * FROM table1 ORDER BY rand() LIMIT 1  To query  SELECT * FROM table1 WHERE id=(SELECT id FROM table1 ORDER BY rand() LIMIT 1)

Query result set, randomly sorted

SELECT * FROM table1 ORDER BY rand() 

MS SQL Server

SELECT *
 　　 FROM Northwind Orders 
 　　 ORDER BY NEWID() 
SELECT TOP 10 * 
 　　 FROM Northwind Orders 
 　　 ORDER BY NEWID()