IT의 신

오라클 페이징 쿼리 원리 select a.*from(select row_number() over(order by app asc) as r_num,count(*) over () as totcount,(row_number() over (order by app desc)) page0,(row_number() over (order by app desc)-1) / 5 as page1,floor( (row_number() over(order by app desc)-1) -1 / 5 +1 ) as page0from table)a; 결과:r_numtotcountpage0page1page1001001019910020.219810030.419710040.619610050.81951006129410071.229310081...