--Select random rows with Microsoft SQL Server
--NEWID Creates a unique value of type uniqueidentifier.
SELECT * FROM table ORDER BY NEWID()
--Select random rows with MySQL
SELECT * FROM table ORDER BY RAND()
--Select random records with Oracle:
SELECT * FROM table ORDER BY dbms_random.value
