Database

[ORACLE]데이터 페이징 처리방법(게시판)

애플자라 2012. 10. 11. 17:00
반응형
SELECT B.*
FROM ( SELECT ROW_NUMBER() OVER(ORDER BY DATE DESC) RNUM,A.*
            FROM TABLE A ) B
WHERE RNUM BETWEEN 1 AND 50
반응형