Skip to Main Content
Forums

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!

Limiting the number of rows returned.

Marius2Nov 1 2006 — edited Nov 2 2006
Is it posible to make a query and say that you only want the x first rows returned?

Like: Select * from some_table LIMIT 4; (and get only the first 4 rows from select * from some_table; returned)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2006
Added on Nov 1 2006
16 comments
1,628 views