Re: nested SQL query

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Mon, 28 Jan 2002 17:51:59 GMT
Message-ID: <3c558f42.1318124@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 Mon Jan 28 2002 - 11:51:59 CST