Re: TOP N syntax in Oracle 9i.

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 - 06:59:44 CDT