Oracle Reports (MOSC)

MOSC Banner

USAGE OF GROUP BY CLAUSE

edited Jan 21, 2011 2:44AM in Oracle Reports (MOSC) 1 commentAnswered
How we use  wdj.PLAN_MAINTENANCE  with SELECT Where as i dont  to want  it with  GROUP BY ?

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center