Re: Help needed: Oracle ans SQL

From: Mirko Cegledi <mcegledi_at_itprotect.de>
Date: Wed, 17 Oct 2001 16:48:54 +0200
Message-ID: <3BCD9A56.15204474@itprotect.de>

Thomas Kyte wrote:

> sigh, never any versions. oh well.

Sorry, forgot that. We're using 8.0.5 around here.

> scott_at_ORA717DEV.US.ORACLE.COM>
> scott_at_ORA717DEV.US.ORACLE.COM> select distinct key,
> first_value(value) over ( partition by key
> 2 order by lvl DESC nulls last ),
> 3 first_value(lvl) over ( partition by key
> 4 order by lvl DESC nulls last )
> 5 from t
> 6 /

Er.... yes. Looks interesting. Unfortunately, I saw a lot of keywords never before in a context with SQL. This works since which version?

TIA, Mirko Received on Wed Oct 17 2001 - 09:48:54 CDT