Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Tuesday, May 30, 2006

Pagination Query

select col1,col2,(select count(col3) from table1 ) cnt
from (select a.*, rownum rnum
from (select *
from table1
order by col1
) a
where rownum <= 550)
where rnum >= 525;

0 Comments:

Post a Comment

<< Home