Posted by Andy Hassall on 09/18/06 21:05

On Mon, 18 Sep 2006 10:30:46 +0200, "KrunoG" <bezovogRad.astronomija@gmail.com>
wrote:

>I've wrote a statement which generates 150.000 rec's, randomized it and now
>I would like to export 1st 10.000 rows (take the sample of data) but don't
>know how (?)
>I would appreciate any help

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

[Back to original message]