SELECT ROWNUM 간단 예시

SELECT 할때 간단 ROWNUM 으로 표출 수 제어하기 !!

SELECT * FROM ( 
SELECT 
A.DATA_NO 
,A.DATA_ID 
,A.DATA_TITLE 
,TO_CHAR(A.MODIFY_DATE, 'YYYY-MM-DD') AS MODIFY_DATE 
,TO_CHAR(A.REGISTER_DATE, 'YYYY-MM-DD') AS REGISTER_DATE 
FROM DATA A 
WHERE 1=1 
AND A.DELETE_STATUS ='N' 
ORDER BY A.DATA_NO DESC 
) WHERE ROWNUM <= 2