Re: Get first 10 records?
From: sanrakvis <member_at_dbforums.com>
Date: 25 Oct 2001 17:10:54 -0500
Message-ID: <3bd87fde$1_at_usenetgateway.com>
Date: 25 Oct 2001 17:10:54 -0500
Message-ID: <3bd87fde$1_at_usenetgateway.com>
There is new option called sample is Oracle8i. You could use it to get a random sample of rows.
Eg. To return the 1%of rows form the emp table one could use
Select * from emp sample(1)
-- Posted via dBforums http://dbforums.comReceived on Fri Oct 26 2001 - 00:10:54 CEST