WITH t AS
(
SELECT '1' c FROM dual
UNION ALL SELECT '3' FROM dual
UNION ALL SELECT '5' FROM dual
--UNION ALL SELECT '7' FROM dual
)
SELECT c || CASE WHEN LEAD(c) OVER(ORDER BY c) IS NULL THEN '*' END c
FROM t
;
by sm5
[2020.02.13 14:24:01]
와..해결하였습니다.
정말 감사드립니다..
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.