Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed: Oracle ans SQL
In article <3BCD9A56.15204474_at_itprotect.de>, Mirko says...
>
>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
these analytic functions as they are called are supported with Oracle8i release 2 (8.1.6) and above.
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Wed Oct 17 2001 - 12:44:01 CDT