Re: First 20 records from a select, after ordering

> > >
> > > If you don't want to use PL/SQL then you could do something like this:
> > >
> > > SELECT *
> > > FROM (SELECT <columns>
> > > FROM <tablename>
> > > ORDER BY <column>)
> > > WHERE rownum < 21
> > >
> > > This would do your job. HTH
> >
> > I thought this was only available in 8i, not 8....
> >

> I don't see why it wouldn't work in earlier versions than that.

This is definitely a feature since Oracle 8.xxxx. Ora 7.x cant do this.

It seems not to function in Oracle 8.0.5 as I tried it

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------