[Mysql] 다음글, 이전글 쿼리처리

SELECT

*

,(SELECT NOTI_SN  FROM TBL_NOTICE WHERE NOTI_SN < '7' AND DEL_YN ='N' ORDER BY NOTI_SN DESC LIMIT 1) AS PREV_SN

,(SELECT NOTI_SN  FROM TBL_NOTICE WHERE NOTI_SN > '7' AND DEL_YN ='N' ORDER BY NOTI_SN LIMIT 1) AS NEXT_SN

 FROM 

TBL_NOTICE

 WHERE

  NOTI_SN ='7';