Select Random Rows from Table in Oracle

To select 10 random records from a table in Oracle

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

 

Category: Database • SQL

Tags: • • • •

Leave a Reply

Article by: Shadab Mohammad