Re: nested SQL query

From: Tom Dyess <tdyess_at_dyessindustries.com>
Date: Tue, 29 Jan 2002 20:02:56 GMT
Message-ID: <QdD58.482740$oj3.91085720@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 - 14:02:56 CST