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 - 10:10:44 CST
