I want to use below select query with if condition or decode, is it possible:
SELECT 'ACTUAL' || '2013' AS DataSet,
Company AS Facility,
'99000004' AS Sub_Account,
'S' AS Account_Type,
SUM((CR_Units_01 + DB_Units_01)/177.14) AS Month1,
--I want to use the below line script if sysdate month is greater than 2 else '0' as month2,
SUM((CR_Units_01 + DB_Units_01 + CR_Units_02 + DB_Units_02)/177.14) AS Month2,
--I want to use the below line script if sysdate month is greater than 3 else '0' as month3,
SUM((CR_Units_01 + DB_Units_01 + CR_Units_02 + DB_Units_02 + CR_Units_03 + DB_Units_03)/177.14) AS Month3,
I want to use this logic till month 12.
Thank you very much for the helpful info.
within select query using if condition base on mth
Posted - 02/07/2013 : 07:56:12
