Tuesday, August 27, 2013

How do you select random rows in Oracle?

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

No comments :