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!

Rownum

542647Feb 11 2008 — edited Feb 11 2008

Hi,

Can i have a way out where i can take out data lets say from row 5 to 10 without couting all the records on table.Lets say i have a table emp where i have N number of records.i want to list records from row 5 to 20 without checking total number of records exist in emp table to reducre the time in that query.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2008

Added on Feb 11 2008

29 comments

746 views