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
FROM ( SELECT ROW_NUMBER() OVER(ORDER BY DATE DESC) RNUM,A.*
FROM TABLE A ) B
WHERE RNUM BETWEEN 1 AND 50
반응형