SELECT LEVEL lv
, y - CEIL((LEVEL - s) / 2) year
, MOD(LEVEL + s, 2) + 1 semester
FROM (SELECT 2021 y, 1 s FROM dual)
CONNECT BY LEVEL <= 6
;
WITH t(lv, y, s) AS
(
SELECT 1 lv
, 2021 y
, 1 s
FROM dual
UNION ALL
SELECT lv + 1
, y - MOD(s, 2)
, MOD(s, 2) + 1
FROM t
WHERE lv < 6
)
SELECT *
FROM t
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.