What if the number of rows in the table changes dynamically?
Just curious..
- Kirti Deshpande
> -----Original Message-----
> From: Shakeel Qureshi [SMTP:msklq_at_yahoo.com]
> Sent: Friday, January 12, 2001 12:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Random data retrieval
>
>
> select xxxx from A sample(1)
> where bidrate=xxx
> Depending upon no of rows in table you can modify
> sample by prefixing decimals.
>
> Regards,
>
> Shakeel Qureshi
> DBA (Oracle Certified)
> squreshi_at_barpoint.com
> --- Sachin Puri <sachin_at_siworldwide.com> wrote:
> >
> > i am using Oracle 8i only .
> > I know that command (i.e sample) however not sure
> > how to use this command.
> > Can u tell me how to use this in the query.
> >
> > Thanks in advance.
Received on Fri Jan 12 2001 - 13:43:36 CST
