Analytical functions have been around at least from 8.1.7, 2-3 years.
"Đuro Dretvic" <Djuro.Dretvic_at_Infodom.hr> wrote in message
news:aam0o3$4kn$1_at_sunce.iskon.hr...
> I agree with all you gentleman about my lazyness. I apologize for that.
>
> But I thought that maybe Oracle would have implemented such a keyword in
9i
> version. I have read new features in Oracle 9i but I have not found
> anything that is similar to that. That is something what I don't expect
from
> Microsoft (there are a lot of things missing in SQL Server 2000 which is
> contained in Oracle 9i respectively), but Oracle is a serious RDMBS and
in
> my opinion it should have it.
> I don't prefer to write every time subquery for that purpose.
>
>
> Regards Djuro.
>
>
>
> "Dusan Bolek" <pagesflames_at_usa.net> wrote in message
> news:1e8276d6.0204300303.210aebc_at_posting.google.com...
> > Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> news:<l2mqcuggnfse3vuusmtvr19ao4qictvg03_at_4ax.com>...
> > > >How do I retrieve first N rows from table or view in Oracle 9i ?
> > > >Example of T-SQL in MS SQL Server 2000.
> >
> > > http://tahiti.oracle.com has all 9i docs including the sql reference
> > > manual. The paragraph on SELECT would typically contain the correct
> > > answer.
> >
> > And I'll be the second "unfriendly" one, because there is also need to
> > mention groups.google.com (formerly dejanews.com), where just simple
> > search with "TOP N" as keyword returns a lot of correct responses,
> > because this question is one of the most popular here.
> >
> > > Sybrand Bakker, Senior Oracle DBA
> > >
> > > To reply remove -verwijderdit from my e-mail address
> >
> > Still no "-verwijderdit" available in e-mail address. ;-)
> >
> > --
> > _________________________________________
> >
> > Dusan Bolek, Ing.
> > Oracle team leader
> >
> > Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> > can call it an overture to bankruptcy) on that server. I'm still using
> > this email to prevent SPAM. Maybe one day I will change it and have a
> > proper mail even for news, but right now I can be reached by this
> > email.
>
>
Received on Tue Apr 30 2002 - 09:20:30 CDT
