반응형

Select outer_paging_tbl.*
From (
Select rownum as paging_seq
, inner_paging_tbl.*
From ( 쿼리쿼리쿼리 ) inner_paging_tbl.*
Where rownum <= (:request_page * :row_num)
) outer_paging_tbl
Where paging_seq >= (:request_page-1) * (:row_cnt)+1

반응형