Lance,
Lance,
You are asking for help in the wrong place. MySQL doesn't issue Oracle
error messages. Only Oracle issues Oracle error messages. Try www.oracle.com.
When you go there, they will surely ask you what in the world you are
trying to do. They might suggest that you start by defin
SELECT
ROUND(AVG(COUNT(Time_stamp))),
MIN(COUNT(time_stamp)),
MAX(COUNT(time_stamp))
FROM
cp_license_use
Where time_stamp = parmTime
and time_stamp >= SYSDATE-7
group by Time_Stamp)
On Mon, Jan 28, 2002 at 05:27:15PM -0800, Lance
At 05:27 PM 1/28/2002 -0800, Lance Prais wrote:
>Why when I use the following SQL it get a
>ORA-00937: not a single-group group function
>
>What could I be doing wrong?
>
>I am only trying to group on Time_stamp.
>
>Thank you in advance
>
>SELECT
> ROUND(AVG(COUNT(Time_stamp))),
>
Why when I use the following SQL it get a
ORA-00937: not a single-group group function
What could I be doing wrong?
I am only trying to group on Time_stamp.
Thank you in advance
SELECT
ROUND(AVG(COUNT(Time_stamp))),
MIN(COUNT(time_stamp)),
MAX(COUNT(time_stamp)),
2001 10:54
To: Daniel Kirk; [EMAIL PROTECTED]
Subject: Re: group by error in query
On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote:
> Hi,
>
> I've just ported from SQLServer where this query ran fine, however MySQL
> gives an "invalid use of group function" er
On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote:
> Hi,
>
> I've just ported from SQLServer where this query ran fine, however MySQL
> gives an "invalid use of group function" error.
>
> Any ideas?
>
> thx
>
> dan
>
> select us.username, us.id as userid, count(*) as tips from User
Hi,
I've just ported from SQLServer where this query ran fine, however MySQL
gives an "invalid use of group function" error.
Any ideas?
thx
dan
select us.username, us.id as userid, count(*) as tips from UserTippingInfo
u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND
m.match
Hi,
I've just ported from SQLServer where this query ran fine, however MySQL
gives an "invalid use of group function" error.
Any ideas?
thx
dan
select us.username, us.id as userid, count(*) as tips from UserTippingInfo
u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND
m.match