Enviado em 12/12/2018 - 11:15h
Galera preciso subtrair valor de uma coluna com outra, e mostra o resultado em uma nova coluna estou tentando via case, alguém pode ajudar?
SELECT start_date,
metric_id,CONTROL_POINT_ID, MODULE_ID,
CASE
WHEN metric_id in('RAEMM156') THEN METRIC_AMOUNT_QTD
ELSE 0
END AS RAEMM156,
CASE
WHEN metric_id in('RAEMM148') THEN METRIC_AMOUNT_QTD
ELSE 0
END AS RAEMM148
FROM RD_T_EDR_DETAILED_EMM
WHERE METRIC_ID IN ('RAEMM148','RAEMM156')
AND START_DATE = to_date('04/12/18','DD/MM/YY')
--GROUP BY metric_id,
-- start_date,CONTROL_POINT_ID,MODULE_ID
order by start_date desc;
RETORNO:
START_DATE METRIC_ID CONTROL_POINT_ID MODULE_ID RAEMM156 RAEMM148
---------- --------------- ---------------- ---------- ---------- ----------
04/12/18 RAEMM148 ENT H72 0 9802
04/12/18 RAEMM156 ENT H74 20857 0
04/12/18 RAEMM148 ENT H72 0 18921186
04/12/18 RAEMM156 ENT H74 27974302 0
SELECT start_date,
metric_id,CONTROL_POINT_ID, MODULE_ID,
CASE
WHEN metric_id in('RAEMM156') THEN METRIC_AMOUNT_QTD
ELSE 0
END AS RAEMM156,
CASE
WHEN metric_id in('RAEMM148') THEN METRIC_AMOUNT_QTD
ELSE 0
END AS RAEMM148
FROM RD_T_EDR_DETAILED_EMM
WHERE METRIC_ID IN ('RAEMM148','RAEMM156')
AND START_DATE = to_date('04/12/18','DD/MM/YY')
--GROUP BY metric_id,
-- start_date,CONTROL_POINT_ID,MODULE_ID
order by start_date desc;
RETORNO:
START_DATE METRIC_ID CONTROL_POINT_ID MODULE_ID RAEMM156 RAEMM148
---------- --------------- ---------------- ---------- ---------- ----------
04/12/18 RAEMM148 ENT H72 0 9802
04/12/18 RAEMM156 ENT H74 20857 0
04/12/18 RAEMM148 ENT H72 0 18921186
04/12/18 RAEMM156 ENT H74 27974302 0