How to use "rownum"

[sameera s]

Hi,
I am doing a paging task. In order to do that I want to get data 10 by 10 raws from a table. How can I do this using "rownum" ?
I tried in this way

SELECT FROM (
SELECT UPLOAD_DATE_TIM E,TYPE_OF_UPLOA D,PERFORMED_BY, STATUS,CLFILE_C OUNT,STCMAS_COU NT,CLSTMAS_COUN T,OPENTRN_COUNT ,START_TIME,FIN ISH_TIME,rownum rn
FROM ONLINE_ACTION_H ISTORY where TYPE_OF_UPLOAD= 'OPERATIONAL' ORDER BY UPLOAD_DATE_TIM E DESC) WHERE rn between 1*10-9 and 1*10;

But row numbers are not in the order as table rows. It has different order. Please help me to solve this problem.
Thanks in advance

[amitpatel66]

Try this:

[code=oracle]
SELECT * FROM(
SELECT UPLOAD_DATE_TIM E,TYPE_OF_UPLOA D,PERFORMED_BY, STATU S,CLFILE_COUNT, STCMAS_COUNT,CL STMAS_COUNT,OPE NTRN_ COUNT,START_TIM E,FINISH_TIME,r ownum rn FROM (
SELECT UPLOAD_DATE_TIM E,TYPE_OF_UPLOA D,PERFORMED_BY, STATU S,CLFILE_COUNT, STCMAS_COUNT,CL STMAS_COUNT,OPE NTRN_ COUNT,START_TIM E,FINISH_TIME
FROM ONLINE_ACTION_H ISTORY where TYPE_OF_UPLOAD= 'OPERATIONAL' ORDER BY UPLOAD_DATE_TIM E DESC))
WHERE rn between 1*10-9 and 1*10
/
[/code]

[sameera s]

I tried it and it works
Thanx Amith... :)