方法一:
SELECT m.*
FROM (SELECT u.* FROM USER_INFO u order by dbms_random.value()) m
where rownum < 100;
注:USER_INFO约40w条数据.
方法二:
SELECT * FROM USER_INFO SAMPLE(50) WHERE ROWNUM < 101;
SELECT m.*
FROM (SELECT u.* FROM USER_INFO u order by dbms_random.value()) m
where rownum < 100;
注:USER_INFO约40w条数据.
SELECT * FROM USER_INFO SAMPLE(50) WHERE ROWNUM < 101;