Oracle随机获取记录

1 SELECT A.* FROM TableA A CROSS JOIN (SELECT TRUNC(DBMS_RANDOM.VALUE(0,  999999999999999999999)) RANDOMNUM FROM DUAL) B ORDER BY B.RANDOMNUM
原文地址:https://www.cnblogs.com/yomho/p/3745065.html