Oracle 随机抽取数据

select * from (select * from nltcp_dm_gy_hy where sjhy_dm = '348' order by dbms_random.value) where rownum <= 2;

 

posted @ 2016-06-04 15:32  IAMME  阅读(1169)  评论(0编辑  收藏  举报