Re: Select random rows?

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