黑黑,这些个SQL有意思,不过也只是个思路,在大记录量情况下,效率都不好~~
1、select * from tables sample(1) where rownum < 10
2、select * from (select *from table order by trunc(dbms_random.value(0,1000))) where rownum<10;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7607759/viewspace-22214/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7607759/viewspace-22214/