Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Help: Need Random sample of 3K from a query returning 100K

Help: Need Random sample of 3K from a query returning 100K

From: George <ghharrac_at_neodata.com>
Date: 2000/04/17
Message-ID: <8dfg7o$1tr$1@nnrp1.deja.com>#1/1 






Can oracle return a Random Sampling (Nthing) of 3K records from 10K
records/tuples that my select statement returns?



Oracle 8 has a feature to do this but the size of the return
set is also random, which I cannot use.



The returned data does not have to be statistically sampled.



George



Please directly email me.





Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Mon Apr 17 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US