SELECT COUNT(A_IDX) AS TOTAL_CNT FROM CS_NOTICE WHERE 1=1 AND USE_FLAG = 'Y' SELECT * FROM (
SELECT CS_NOTICE.*, ROW_NUMBER() OVER(ORDER BY A_IDX DESC) AS RNUM, TO_CHAR(CS_NOTICE.REG_DATE, 'YYYY.MM.DD') RD FROM CS_NOTICE
WHERE 1=1 AND USE_FLAG = 'Y' ORDER BY A_IDX DESC ) WHERE RNUM < 6 AND RNUM > 0
