I would like to know, whether I can query a table based on the rownum.
for example, If I want the records from 5000 to 10000 in the table : Can I use
select * from table_name
where rownum between 5000 and 10000;
Results 1 to 8 of 8
Click Here to Expand Forum to Full Width