DB
이전글 다음글 select 쿼리
bbuljj
2014. 4. 17. 16:25
1. 이전글 다음글 SELECT 하는 쿼리
1) 다음글
SELECT
BOARD_SEQ
FROM
BOARD
where
BOARD_SEQ = (
SELECT
MIN(BOARD_SEQ)
FROM
BOARD
where
delete_yn IS NULL OR delete_yn = 'N'
AND BOARD_SEQ >현재글번호
)
2) 이전글
SELECT
BOARD_SEQ
FROM
BOARD
where
BOARD_SEQ = (
SELECT
MAX(BOARD_SEQ)
FROM
BOARD
where
delete_yn IS NULL OR delete_yn = 'N'
AND BOARD_SEQ <현재글번호
)
(*) 출처 : http://byulbada.egloos.com/