Re: Select random rows

Oracle8i also has sample capability, i.e

SELECT SUM(sales_dollar_amount)*10 FROM sales SAMPLE BLOCK(10);

will sample 10% of the blocks in the sales table. You can also sample a percentage of rows.

Steven R Fuller wrote:
>
> use the mod function
>
> earthlink wrote:
>
> > Is there a way to select a set number of rows randomly from a table?
> > Hope someone could help

--
Regards,

Mark Townsend                         

Senior Product Manager				Ph: 	(650) 633 5764
Server Division					Fx: 	(650) 506 7222
Oracle Corporation				Email:	mtownsen_at_us.oracle.com