Archives of the TeradataForum
Message Posted: Fri, 22 Mar 2002 @ 09:38:05 GMT
<-- Anonymously Posted: Thursday, March 21, 2002 23:05 -->
If you are running out of SPOOL on SAMPLE and you are one release 4 you might use the RAMDOM function.
Sel * from table
This will only select rows when the random number generator returns a value of 1. This should be roughly 1% of the time. Then, if you needed a specific number of rows, combine the RANDOM with the SAMPLE. It will use less SPOOL and give you a random sample.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|