select * from (select * from tablename order by sys_guid()) where rownum < N;
select * from (select * from tablename order by dbms_random.value) where rownum< N
实现从Oracle中随机取得几条记录
最新推荐文章于 2021-04-02 21:57:21 发布