Random Query

Oracle

SELECT * FROM emp SAMPLE(5)

 

MSSQL

SELECT TOP 5 * FROM emp ORDER BY NEWID()

 

MySQL

SELECT * FROM emp ORDER BY RAND() LIMIT 0, 5