SELECT round(exp(SUM(LN(LOSAL))))
FROM (SELECT 1 AS GRADE,700 AS LOSAL FROM DUAL UNION ALL
SELECT 2 AS GRADE,1201 AS LOSAL FROM DUAL UNION ALL
SELECT 3 AS GRADE,1401 AS LOSAL FROM DUAL UNION ALL
SELECT 4 AS GRADE,2001 AS LOSAL FROM DUAL UNION ALL
SELECT 5 AS GRADE,3001 AS LOSAL FROM DUAL
)
FROM (SELECT 1 AS GRADE,700 AS LOSAL FROM DUAL UNION ALL
SELECT 2 AS GRADE,1201 AS LOSAL FROM DUAL UNION ALL
SELECT 3 AS GRADE,1401 AS LOSAL FROM DUAL UNION ALL
SELECT 4 AS GRADE,2001 AS LOSAL FROM DUAL UNION ALL
SELECT 5 AS GRADE,3001 AS LOSAL FROM DUAL
)
'Oracle' 카테고리의 다른 글
| 중복된 값의 REPLACE 하는 방법 (0) | 2006.06.09 |
|---|---|
| bitmap index (0) | 2006.06.07 |
| SQLCODE RESULT값 (0) | 2006.05.09 |
| 날짜FORMAT변경 (0) | 2006.05.09 |
| CONSTRAINT 정보 조회 (0) | 2006.05.09 |
