by 손님 [2007.05.14 16:24:30]
WITH TEST AS (
SELECT 30 A FROM DUAL UNION ALL
SELECT 100 FROM DUAL UNION ALL
SELECT 20 FROM DUAL UNION ALL
SELECT 50 FROM DUAL UNION ALL
SELECT 80 FROM DUAL
)SELECT SUM(A) FROM TEST <= 이것은 합계 내는 방법
여기서 전체 곱을 구하는 방법.