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: DatabaseSQL

Tags:

Leave a Reply

Article by: Shadab Mohammad