Re: TOP N syntax in Oracle 9i.

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.