OraFAQ Forum: SQL & PL/SQL » [RAVI] ORA-00937: not a single-group group function

Home » SQL & PL/SQL » SQL & PL/SQL » [RAVI] ORA-00937: not a single-group group function

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

[RAVI] ORA-00937: not a single-group group function [message #893]

Mon, 11 March 2002 11:24

Ravi
Messages: 251
Registered: June 1998

Senior Member

Hi,

I wanted to count number of record per day for a week,
I am getting following error, Pl help me if you know answer., Thanks a lot

SELECT TO_CHAR(create_date,'MM-DD-YY'),count(*) FROM message WHERE msg_name='FISUpdateError' and create_date > sysdate -8
*
ERROR at line 1:
ORA-00937: not a single-group group function

Report message to a moderator

Re: [RAVI] ORA-00937: not a single-group group function [message #894 is a reply to message #893]

Mon, 11 March 2002 11:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try this
SELECT TO_CHAR(create_date,'MM-DD-YY'),count(*) FROM message WHERE msg_name='FISUpdateError' and create_date > sysdate -8
group by create_date

Report message to a moderator

Re: [RAVI] ORA-00937: not a single-group group function [message #900 is a reply to message #893]

Mon, 11 March 2002 23:02

THA
Messages: 26
Registered: February 2002

Junior Member

hello
the query is perfect. no need to trim. just use the function sum instead of count.
thanks

Report message to a moderator

Re: [RAVI] ORA-00937: not a single-group group function [message #916 is a reply to message #893]

Tue, 12 March 2002 19:06

Jim Willis
Messages: 11
Registered: October 2001

Junior Member

try "TRUNC"
SELECT TO_CHAR(TRUNC(create_date,'MM-DD-YY')),count(*) FROM message
WHERE msg_name='ExodusUpdateError' and
create_date > sysdate -8
group by create_date

Report message to a moderator

Previous Topic:	eliminating rows when more than one rows has been returned
Next Topic:	sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 00:16:21 CDT 2024