Re: SQL question - Addendum

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 10 Feb 2003 09:17:19 -0800
Message-ID: <3E47DE9F.AEED0D28@exesolutions.com>

"Jason D." wrote:

> I have a table called EMPLOYEES and I have a select statement with which I
> retrieve 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.

PS: And we do not do people's class assignments for them so in the future please indicate if you are a student and post your best attempts when asking for help. Also, be sure to include Oracle version number.

Daniel Morgan Received on Mon Feb 10 2003 - 11:17:19 CST