[오라클 Oracle] ROW_NUMBER() OVER(ORDER BY ) 예제

SELECT * 
  FROM (
    SELECT ROWNUM, SUBJECT
	     , ROW_NUMBER() OVER(ORDER BY NOTICE_YN DESC, UPDATE_DT DESC) AS RNUM 
	  FROM BOARD 
	 WHERE BOARD_ID = 'MAIN' 
  ) 
 WHERE 
  RNUM <= 10;

위와 같이 최근게시물 불러올 때 유용하겠다.