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

Home -> Community -> Mailing Lists -> Oracle-L -> Random Select of X % of total records

Random Select of X % of total records

From: Kevin Lange <klange_at_ppoone.com>
Date: Fri, 7 Oct 2005 15:07:25 -0500
Message-ID: <ED1256BD4F253C44B1627B2D365A334F08767034@ppoone1.ppoone.com>


Evening all;
  One of our developers is asking if there is a simple SQL way to generate a random select of the total records in a table. i.e. They want to see 10% of the records in the CLAIMS table.  

Database in question is 9i (9.2.0.6)  

SQL has to be simple because its going to be used by Cognos which does not allow anonymous sql blocks.  

I was hoping that some of the new analytical functions would work for this but I have not used them yet.  

Any help out there ??

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 07 2005 - 15:10:45 CDT

Original text of this message

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