Re: How would you retrieve the first five records

Sorry Ken, but you cannot put an ORDER BY statement in the subquery until Oracle8 v8.1.

Rgds
Andrew

Ken Geis wrote:

> You can actually do this with Oracle 7.3.3 and later.
>
> That first line is "select * from" though.
>
> Ken
>
> Bert Scalzo wrote:
> >
> > In Oracle 8i (i.e. 8.1.5) you can do this easily via inline views:
> >
> > select *
> > (select * from employee order by salary)
> > where rownum <= 5;
Received on Mon Mar 29 1999 - 18:32:53 CST