Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 2:29 PM
To: Black, Kelly W [PCS]
Subject: RE: Interesting Challenge
> I have tried with and without having. Neither works.
>
> If you try running the query without cell, or sector, the
>
I know this is not elegant, but have have you tried using a temporary
table? It adds up your function column correctly. There was an
example of this earlier today from Oyekanmi - "Re: getting around a
subselect",
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:123911:200211:onbajmklkgifeckohcpa
This simply returns me to the documentation.
Thanks
-Original Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 12:13 PM
To: Mysql (E-mail)
Subject: RE: Interesting Challenge
> mysql> SELECT cell, sector,
If you only want one row
> mysql> SELECT cell, sector,
If you only want one row, then selecting cell doesn't make any sense.
Cell is different in each row you've selected. If you only want one
row, don't select cell.
> -> sum(att) as att,
> -> sum(lc) as lc,
> -> sum(csh) as csh,
> -> ROUND((SUM( lc + cs
Hi sql query wizards!
I need some help.
Is there a way I can take this query here =>
mysql> SELECT cell, sector,
-> sum(att) as att,
-> sum(lc) as lc,
-> sum(csh) as csh,
-> ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc +
suf)),2) AS drops,
-> sum(tccf) as
