데이터베이스 질문과 답변
by 마농
[2022.03.20 22:37:49]
WITH t AS
(
SELECT 1 seq FROM dual
UNION ALL SELECT 2 FROM dual
--UNION ALL SELECT 3 FROM dual
UNION ALL SELECT 4 FROM dual
UNION ALL SELECT 5 FROM dual
)
SELECT NVL(MIN(seq), 0) + 1 new_seq
FROM (SELECT seq
, LEAD(seq) OVER(ORDER BY seq) next_seq
FROM t
)
WHERE next_seq != seq + 1
OR next_seq IS NULL
;
by 아침이네
[2022.03.21 14:30:37]
감사합니다
) 버튼을 클릭하여 작성 하시면 됩니다.