การเรียงลำดับข้อมูลจากฐานข้อมูลแบบสุ่ม

SELECT * FROM tablename ORDER BY RAND() LIMIT 10

SELECT * FROM tablename ORDER BY RANDOM() LIMIT 10

SELECT TOP 10 * FROM tablename ORDER BY NEWID()

SELECT *, RAND() AS idx FROM tablename ORDER BY idx FETCH FIRST 10 ROWS ONLY

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