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!

How to query only a few rows

124363Jan 27 2002

For a table with millions of rows, I want to sample a few rows to have some general idea of the data.
Is there any general way to get specif rows? For example, can I only query the first or last 20 rows of the table?
Please assume I have no specific criteria as filter.
Thanks a lot!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2002

Added on Jan 27 2002

3 comments

341 views