SELECT *
FROM (
SELECT 'A' AS FLAG, 1500 AS CAL FROM DUAL UNION ALL
SELECT 'B' AS FLAG, 60 AS CAL FROM DUAL UNION ALL
SELECT 'C' AS FLAG, 30 AS CAL FROM DUAL UNION ALL
SELECT 'D' AS FLAG, 200 AS CAL FROM DUAL UNION ALL
SELECT 'E' AS FLAG, 0 AS CAL FROM DUAL UNION ALL
SELECT 'F' AS FLAG, 250 AS CAL FROM DUAL UNION ALL
SELECT 'G' AS FLAG, 330 AS CAL FROM DUAL
)
;
E = A - D - F
950 = 1500 - 200 - 250
어떻해 하면 E에 1050을 채워 넣을수 있을까요
결과
A 1500
B 60
C 30
D 200
E 1050
F 250
G 330
고수님들 좀 알려주세요. 하루종일 했는데 답을 못 구했어요.ㅠㅠ |