[SQL] 이전, 다음 - 조회

MYSQL사용 했습니다~

WITH RankedData AS (
    SELECT
       SEQ,
       TITL,
       EXPS_YN,
       LNGG_CD,
       POST_DD,
       ROW_NUMBER() OVER (ORDER BY POST_DD DESC, REG_DTM DESC) AS rank
    FROM 테이블명
    WHERE
    1=1
    AND EXPS_YN = 'Y'
	AND POST_DD <![CDATA[<=]]> DATE_FORMAT(NOW(), '%Y-%m-%d')
)
SELECT
    P.PRSS_MATLS_SEQ AS prevSeq,
    P.TITL AS prevTitl,
    N.PRSS_MATLS_SEQ AS nextSeq,
    N.TITL AS nextTitl
FROM
    RankedData C
       LEFT JOIN RankedData N ON N.rank = C.rank - 1
       LEFT JOIN RankedData P ON P.rank = C.rank + 1
WHERE C.SEQ = #{seq}