Re: First

Peter Plumber wrote:

> Hi,
>
> Does Qracle 9i support a SELECT that returns
> only a subset of the records
>
> something link
>
> SELECT FIRST 1 * FROM tablename
>
> thx
>
> Peter

Look at ROWNUM ....

but, in a system that does not, by definition, have any knowledge of 'order of input', what do you mean by 'first'????

/Hans Received on Wed Aug 04 2004 - 11:09:19 CDT