Actually it is indexed and assigning a row num wouldn't really make the
selection random, I will be probably be getting the same record for the same
parameters.
"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:8aQ1a.62560$be.48274_at_rwcrnsc53...
> If the set isn't ordered then just take the "first one" add rownum=1 to
the
> select.
> Jim
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can
figure
> it out.
> "Jason D." <noonereally_at_vz.net> wrote in message
> news:b28iiv$19tf3t$1_at_ID-157477.news.dfncis.de...
> > I have a table called EMPLOYEES and I have a select statement with which
I
> > retrieve a certain amount of records that fit certain criteria.
> >
> > Is there a way to tweak the select to return only ONE of these records
and
> > preferably a random one?
> >
> > I want to use this select in an automated test case and want to pass
only
> > one set of values at a time.
> >
> >
>
>
Received on Mon Feb 10 2003 - 11:36:01 CST
