USAGE OF GROUP BY CLAUSE
SELECT cdv.DEPARTMENT_CODE Sum_Dept,
cdv.RESOURCE_CODE Sum_Resource,
wdj.PLAN_MAINTENANCE,
CASE wdj.PLAN_MAINTENANCE WHEN 'Y' THEN SUM(cdv.TRANSACTION_QUANTITY) END SUM_PLAN,
CASE wdj.PLAN_MAINTENANCE WHEN 'N' THEN SUM(cdv.TRANSACTION_QUANTITY) END SUM_UPLAN
---- SUM(cdv.TRANSACTION_QUANTITY) Sum_Hours
---
--- CASE wdj.PLAN_MAINTENANCE WHEN 'Y' THEN 'FFF' END PLHRS
--- SUM(cdv.TRANSACTION_QUANTITY) END Sum_Hours,
--- ENDIF;
--CASE LVL.MEANING WHEN 'Complete' THEN '3' END COMPLETE,
/*
cdv.DEPARTMENT_CODE,