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!

Getting a subset of results.

317179Sep 17 2002

I am hoping someone can help me on this, because i really see no other way to do what i need to do.
Is there ANY way, to be able to return ONLY the first X records of a SQL statement... say for example the first 5 records, or the first one record. I am looking for something akin to MS Access' "TOP" functionality.

I have a Single-Row Returning Multiple Rows error, in some legacy code, but the data is needed as is, for other apps, but for this one, we need only the first row, because its being used in an UPDATE.

Any help is greatly Appreciated. Thanks in advance.!!
Cheerz,
Aaron.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 17 2002

Added on Sep 17 2002

3 comments

194 views