Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error ORA-00937

 
Deepakkumar Devarajan
Ranch Hand
Posts: 54
Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

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



Can anyone please help....

Thanks in Advance,
Deepakumar Devarajan

 
Rajkamal Pillai
Ranch Hand
Posts: 445
1
Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

What happens when you execute the query/sub-query from prompt?
 
Deepakkumar Devarajan
Ranch Hand
Posts: 54
Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic