페이징에서 현재 페이지의 게시물만 select하기 아주좋은 쿼리문

SELECT * FROM (
    SELECT rownum as rnum, A.* from (
        SELECT * FROM BOARD_TEST ORDER BY THREAD DESC
    ) A
    ORDER BY rownum DESC
)
WHERE rnum
        BETWEEN
            (([ARTICLE_PER_PAGE]*([CURRENT_PAGE]-1))+1)
            AND
            ([ARTICLE_PER_PAGE]*([CURRENT_PAGE]-1) + [ARTICLE_PER_PAGE])
ORDER BY rnum ASC;