Home » SQL & PL/SQL » SQL & PL/SQL » not a single group function
not a single group function [message #37791] Thu, 28 February 2002 06:05 Go to next message
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
Re: not a single group function [message #37795 is a reply to message #37791] Thu, 28 February 2002 07:16 Go to previous messageGo to next message
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')
Re: not a single group function [message #37800 is a reply to message #37791] Thu, 28 February 2002 08:32 Go to previous message
Krista
Messages: 3
Registered: February 2002
Junior Member
Thank you!
Previous Topic: change sysdate
Next Topic: How to export the selected contents of a table
Goto Forum:
  


Current Time: Thu Mar 28 06:28:31 CDT 2024