Re: TOP N syntax in Oracle 9i.

On Mon, 29 Apr 2002 15:58:01 +0200, "Đuro Dretvić" <Djuro.Dretvic_at_Infodom.hr> wrote:

>Greetings !!!
>
>How do I retrieve first N rows from table or view in Oracle 9i ?
>
>Example of T-SQL in MS SQL Server 2000.
>
>N= 20
>
>SELECT TOP 20 FROM DEPT;
>
>Regards Dj.
>

http://tahiti.oracle.com has all 9i docs including the sql reference manual. The paragraph on SELECT would typically contain the correct answer.
Or is this a quiz question, where the correct responder earns something?
I don't think so, you are probably just too lazy to type the URL

Please do your homework the next time before asking mere doc questions.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Apr 29 2002 - 09:30:31 CDT