SELECT '원가' AS NM, 'COST' AS CD, '원가 * 물가' AS FORM FROM DUAL UNION ALL
SELECT '물가' AS NM, 'PRICE' AS CD, '원가 * 물가' AS FORM FROM DUAL UNION ALL
SELECT '판매가' AS NM, 'SALE' AS CD, '원가 * 물가' AS FORM FROM DUAL UNION ALL
SELECT '고정비' AS NM, 'FIXED' AS CD, '원가 * 물가' AS FORM FROM DUAL ;
'원가 * 물가' --> COST * PRICE 로 한줄 ROW로 공식만 가져올려면 어떻해 SQL을 짜야 할까요?
좀 도와 주세요^^ |