Re: a simple question

first ask yourself what is the meaning of "the first record"...

if it means only return one record, i dont care which one, then use rownum.
otherwise you may be able to use DISTINCT to reduce the result set, or some extra filters in the WHERE clause.

randy

Parvinder Singh wrote:
>
> hi all
>
> if i execute a querry and if that querry's output is a set of records
> ..so it will return back all the records but i want the querry to return
> just the first record from that set of records and not the remaining
> records ....any idea ?
>
> Thanks & Regards
> Parvinder
Received on Tue Nov 30 1999 - 13:01:43 CST