首页 > 代码库 > Oracle随机获取记录

Oracle随机获取记录

1 SELECT A.* FROM TableA A CROSS JOIN (SELECT TRUNC(DBMS_RANDOM.VALUE(0,  999999999999999999999)) RANDOMNUM FROM DUAL) B ORDER BY B.RANDOMNUM