Error ORA-00937

[Deepakkumar Devarajan]

Hi All,

I get the error "ORA-00937 Not a single-group group function" when i execute the below query.

select sm.project_id,sm.process_name,(select round(((sum(s.efr_cnt)/sum(s.ttl_vol))*100),2) from sla s where s.for_mnt between '1-MAY-2011' and '31-MAY-2011' and s.project_id=sm.project_id), (select case when (((sum(s.efr_cnt)/sum(s.ttl_vol))*100)> (select distinct m.efr_mtm from sla m where m.for_mnt between '1-MAY-2011' and '31-MAY-2011' and m.project_id=s.project_id)) then 'Green' when (((sum(s.efr_cnt)/sum(s.ttl_vol))*100) between '95' and '99') then 'Amber' else 'Red' end from sla s where s.project_id=sm.project_id and for_mnt between '1-May-2011' and '31-May-2011') from sla sm group by sm.project_id,sm.process_name

Can anyone please help....

Thanks in Advance,
Deepakumar Devarajan

[Raj Kamal]

What happens when you execute the query/sub-query from prompt?

[Deepakkumar Devarajan]

Raj Kamal wrote:
What happens when you execute the query/sub-query from prompt?

Hi Raj Kamal,

Thanks for your response, When I execute the sub queries seperately I get the actual out put... Or If I hard code the when statement conditions in the above query mentioned, I get the output.