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!

Can one retrieve only the Nth row from a table?

946002Jun 26 2012 — edited Jun 30 2012
Hi,

Can anyone explain the execution order of the below query to fetch the nth row data.

SELECT * FROM t1 a
WHERE n = (SELECT COUNT(rowid)
FROM t1 b
WHERE a.rowid >= b.rowid);

Thanks,
Satya.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2012
Added on Jun 26 2012
8 comments
11,689 views