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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Select random rows?

Re: Select random rows?

From: <jobrien99_at_my-deja.com>
Date: Sat, 06 Nov 1999 00:47:06 GMT
Message-ID: <7vvtqa$ic8$1@nnrp1.deja.com>


Oracle 8i
Use sample keyword,

select * from table sample (10);
 will sample 10% of rows

Knowing the number of rows in the table allows for better chosen percentages to get 10.

Hope that helps.

Regards,
John

In article <3821A42D.6E53D76_at_fast.no>,
  kev <kevin.porter_at_fast.no> wrote:
> Hi,
>
> How do I select, say, 10 random rows from a dataset?
>
> - Kev
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 05 1999 - 18:47:06 CST

Original text of this message

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