WITH T AS (
SELECT LEVEL * 2 SEQ FROM DUAL CONNECT BY LEVEL <= 10
)
SELECT SEQ
, LAG(SEQ) OVER(ORDER BY ROWNUM) PRE_SEQ
, LEAD(SEQ) OVER(ORDER BY ROWNUM) NEXT_SEQ
FROM T
by 마농
[2018.07.06 10:41:46]
SELECT seq
, (SELECT MAX(seq) FROM t WHERE seq < a.seq) seq_pre
, (SELECT MIN(seq) FROM t WHERE seq > a.seq) seq_next
FROM t a
WHERE seq = :v_seq
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.