오라클 - 게시판 이전글 다음글 seq 가져오기

SELECT SEQ, TITLE, NEXT_SEQ, NEXT_TITLE, PRE_SEQ, PRE_TITLE

FROM (

SELECT

  SEQ, TITLE,

  LEAD(SEQ,1,'') OVER(ORDER BY REG_DATE DESC) AS NEXT_SEQ,

  LEAD(TITLE,1,'') OVER(ORDER BY REG_DATE DESC) AS NEXT_TITLE,

  LAG(SEQ,1,'') OVER(ORDER BY REG_DATE DESC) AS PRE_SEQ,

  LAG(TITLE,1,'') OVER(ORDER BY REG_DATE DESC) AS PRE_TITLE

FROM TN_BOARD_NOTICE_WEB

) A

WHERE A.SEQ='해당 게시글 seq 번호'