其他数据库

Oracle 随机取一起数据

2012-11-23

Oracle 随机取一行数据?从表中随机取一条数据select * from (select * from tab order by dbms_random.val

Oracle 随机取一行数据

?从表中随机取一条数据

select * from (select * from tab order by dbms_random.value) where rownum=1 ;?

?出处?http://javas.blog.51cto.com/2153666/457485?

热点排行