SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Returning top 1000 rows

8078Sep 21 2001

Hi guys,

I am new here and I have the dummest question ever, but I don't have the Oracle documentation with me here so here it is: How do I return just the top N rows in a query?

Something like: select top 1000 account_number
from bill_invoice

Does anyone knows how to do it?

thank you

Marcelo Lopes
Rio de Janeiro - Brazil

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2001

Added on Sep 21 2001

6 comments

19,781 views