Oracle AI and Analytics

Neil Kaufman

Summary

Trying to emulate the SQL Group by below in OTBI

Content

Select        pt.task_number,
       sum(peia.projfunc_raw_cost )                         
FROM    pjc_exp_items_all peia,
       pjf_projects_all_b ppb,
        pjf_tasks_v pt
Where
ppb.project_id=pt.project_id
and
pt.task_id= peia.task_id
and task_number='001'
group by task_number
      

Code Snippet

Select        pt.task_number,
       sum(peia.projfunc_raw_cost )                          
FROM    pjc_exp_items_all peia,
       pjf_projects_all_b ppb,
        pjf_tasks_v pt
Where
ppb.project_id=pt.project_id
and
pt.task_id= peia.task_id
and task_number='001'
group by task_number