Posted by KrunoG on 09/19/06 07:33
"Andy Hassall" <andy@andyh.co.uk> wrote in message
news:gb2ug29t6cqqg4c5kb2qhbmnjcjtrv58i7@4ax.com...
> You mentioned "1st" which implies ordering, so order in a subquery, and
use
> "rownum <= 10000" in the outer query to get only that many rows.
>
> Or you've also mentioned sampling; Oracle has a "sample" clause that you
can
> use to get a percentage of the data:
>
>
>
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2065953
>
> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
I've tried this but It's not working
ORDER BY dbms_random.valuerownum <= 10000
Navigation:
[Reply to this message]
|