기존
SELECT * FROM (
SELECT A.*, 
ROWNUM AS RNUM,
COUNT(*) OVER() AS TOTCNT FROM (
쿼리, 조건,정렬
) A
) WHERE RNUM > '부터' AND RNUM <= '까지'


SELECT 
    * 
FROM (
    SELECT 
        ROWNUM AS RNUM
        , A.*
     FROM (
        쿼리, 조건,정렬
     )  A 
     WHERE 
         ROWNUM <= '까지'
)
WHERE 
    RNUM > '부터'