Re: not single- group group function
From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 27 Apr 2004 10:47:58 -0700
Message-ID: <4b5394b2.0404270947.26608c4e_at_posting.google.com>
Date: 27 Apr 2004 10:47:58 -0700
Message-ID: <4b5394b2.0404270947.26608c4e_at_posting.google.com>
The error is due to the nesting of the functions, I believe. IOW,
SUM((AVG(... is not allowed.
Try creating an inline view.
Why the extra set of parentheses?
AND, WHY are you computing it this way?
SUM((AVG(g.grade)*30/100 +AVG(g.grade)*20/100 +AVG(g.grade)*20/100 +AVG(g.grade)*10/100 +AVG(g.grade)*20/100))
Isn't that the same as SUM(AVG(g.grade)) ???? (I don't think my math is that rusty, or is it??)
Ed Received on Tue Apr 27 2004 - 19:47:58 CEST