반응형
Web Programming
-
-
SELECT ROWNUM 간단 예시
Web Programming 2023. 4. 2. 22:11SELECT 할때 간단 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