Using oracle Rownum with between keyword

[Ravi Kiran Va]

Hi ,

I am planning to use JDBC Pagination with Oracle (Query based technique ) No caching of results .

When i tried to use rownum with between Option , it didn't gave me any results

select * from mytable  where rownum between 10 and 20; 

But this gave me results .

select * from mytable  where rownum < 20; 

Please tel me How to solve this ??

[Shinil Mohan]

You can use a nested select to solve this issue. Something like below query

SELECT a, b, c FROM
	(SELECT rownum rn, a, b, c FROM mytable)
WHERE rn BETWEEN 10 AND 20;

[Ravi Kiran Va]

Thank you very much Mohan .

[Shinil Mohan]

You are welcome ..