Oracle随机获取记录
时间:2022-03-10 17:17
1 SELECT A.* FROM TableA A CROSS JOIN (SELECT TRUNC(DBMS_RANDOM.VALUE(0, 999999999999999999999)) RANDOMNUM FROM DUAL) B ORDER BY B.RANDOMNUM
Oracle随机获取记录,布布扣,bubuko.com
时间:2022-03-10 17:17
1 SELECT A.* FROM TableA A CROSS JOIN (SELECT TRUNC(DBMS_RANDOM.VALUE(0, 999999999999999999999)) RANDOMNUM FROM DUAL) B ORDER BY B.RANDOMNUM
Oracle随机获取记录,布布扣,bubuko.com