Select Random Rows from Table in Oracle

Shadab Mohammad

11 years ago

To select 10 random records from a table in Oracle

SELECT * FROM
( SELECT * FROM TABLE_NAME
ORDER BY dbms_random.value )
WHERE rownum <= 10 ;