I need to select rows randomly from an Oracle DB.
Ex: Assume a table with 100 rows, how I can randomly return 20 of those records from the entire 100 rows.
SELECT * FROM ( SELECT * FROM table ORDER BY DBMS_RANDOM.RANDOM) WHERE rownum < 21;
1.4m articles
1.4m replys
5 comments
57.0k users