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!

LIMIT clause

536042Oct 17 2006 — edited Oct 17 2006
When I used MS Access with sql language I remender that for limiting retrieved records of a query I could use:

SELECT TOP 1 * from TABLE_NAME

So I searched for a similar clause for oracle queries and someone pointed me the LIMIT clause.

Could anyone gimme an example on how to use it?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2006
Added on Oct 17 2006
16 comments
448 views