敬业的IT人 >> 数据库 >> Oracle >> Oracle随机抽取记录的方法

Oracle随机抽取记录的方法

敬业的IT人 互联网 佚名 2008-1-8 10:20:30

问：能否给我介绍一种随机抽取记录的方法？

答：以下代码以抽取6条为例：

create table t as select * from all_objects where rownum <= 5000;set timing onselect object_name, object_idfrom ( select object_name, object_idfrom twhere object_name like '%%'order by dbms_random.random )where rownum <= 6;select object_name, object_idfrom ( select object_name, object_idfrom t sample ( 1 )where object_name like '%%'order by dbms_random.random )where rownum <= 6;

粤ICP备06119539号
Copyright CiscoSky.Org,Some Rights Reserved.
Email：me1228#tom.com