Re: Random sample
From: Blv n Drms <blvndrms_at_aol.com>
Date: 1995/04/29
Message-ID: <3nuv0a$eq6_at_newsbf02.news.aol.com>#1/1
Date: 1995/04/29
Message-ID: <3nuv0a$eq6_at_newsbf02.news.aol.com>#1/1
Daniel
If your are trying for 5% Try this:
Select a.*
from datatable a
where decode(mod(rownum,20),0,1,2) = 1;
Jack Richter Received on Sat Apr 29 1995 - 00:00:00 CEST