OraFAQ Forum: SQL & PL/SQL » not a single group function

Home » SQL & PL/SQL » SQL & PL/SQL » not a single group function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

not a single group function [message #19101]

Thu, 28 February 2002 06:04

Krista
Messages: 3
Registered: February 2002

Junior Member

I am getting the following error on my select:

select purch_code, purch_id, net_name,
net_code, net_enroll_ind,
count(perdhis_open_enroll_ind), to_char(net_capture_date,'DD-MON-YYYY')
from purchase, history, customers, orders

ORA-00937: not a single-group group function

would I have to group by here by all the columns selected?

Thank you in advance

Report message to a moderator

Re: not a single group function [message #19105 is a reply to message #19101]

Thu, 28 February 2002 06:52

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

select purch_code, purch_id, net_name,
net_code, net_enroll_ind,
count(perdhis_open_enroll_ind), to_char(net_capture_date,'DD-MON-YYYY')
from purchase, history, customers, orders
group by purch_code, purch_id, net_name,
net_code, net_enroll_ind,
, to_char(net_capture_date,'DD-MON-YYYY')

Report message to a moderator

Previous Topic:	Re: Oracle sysdate to return milliseconds
Next Topic:	Deafult Parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 08:33:36 CDT 2024