WITH T AS (
SELECT 1000 AS BOX_CONT , 450 AS BOX_PACKAGE FROM DUAL
)
SELECT CASE WHEN (BOX_CONT / 450 ) > LEVEL THEN BOX_PACKAGE
ELSE MOD( BOX_CONT , BOX_PACKAGE )
END
FROM T CONNECT BY LEVEL <= ( SELECT CEIL(BOX_CONT / BOX_PACKAGE) FROM T )
by 수예라임
[2018.07.04 15:18:46]
감사합니다.
by 마농
[2018.07.04 15:25:36]
SELECT tot
, box
, LEVEL lv
, LEAST(box, tot - box * (LEVEL - 1)) cnt
FROM (SELECT 1000 tot, 450 box FROM dual)
CONNECT BY LEVEL <= CEIL(tot / box)
;
by 우리집아찌
[2018.07.04 16:14:26]
정말 심플하네요. ㅎㅎ
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.