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;
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.
0 Comments:
Post a Comment
<< Home