My top n example at the co-operative FAQ and (much much better) Jonathan and
Toms books give examples of the syntax.
docs are also available online at http://tahiti.oracle.com
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Tom Dyess" <tdyess_at_dyessindustries.com> wrote in message
news:QdD58.482740$oj3.91085720_at_typhoon.tampabay.rr.com...
> Jaap,
>
> I couldn't find the RANK function in the syntax of the 8i SQL docs -
> (probably because it is pre 8.1.7) could you give an example of the
syntax?
>
> Tom
> www.oraclepower.com
>
> "Jaap W. van Dijk" <j.w.vandijk_at_hetnet.nl> wrote in message
> news:3c558f42.1318124_at_news.freeler.nl...
> > Oracle 8.1.7 SQL (NOT 8.1.5!) features analytic functions, one of
> > which is the RANK function which does exactly what you are looking
> > for.
> >
> > Jaap.
> >
> > On 28 Jan 2002 06:12:49 -0800, erik_lembke_at_web.de (Erik) wrote:
> >
> > >I don't know if this is the correct newsgroup, but I was not able to
> > >find a SQL group.
> > >
> > >Just a short question:
> > >Is it OK to use such SQL Statements:
> > >
> > > select REVISION, SHEETIDX from sheet where REVISION=(select
> > >MAX(REVISION) from SHEET);
> > >
> > >Problem is I want the sheetidx with the highest revision.
> > >
> > >Is there a solution with better performance (without a nest) ?
> > >
> > >regards,
> > >
> > >Erik
> >
> >
>
>
Received on Tue Jan 29 2002 - 15:49:31 CST
