Re: a simple question

I have clearly mentioned in my query that i want the first record from the set of records (those set of records which the query returns)

Thanks & Regards
~Parvinder

Randy DeWoolfson wrote:

> 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 Thu Dec 16 1999 - 03:39:56 CST