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 tccf,
-> sum(bpp) as bpp,
-> sum(bpc) as bpc,
-> sum(suf) as suf,
-> ROUND(SUM( tccf + bpp + bpc + suf) *100 / SUM(att),2) AS blocks,
-> sum(mou) as mou
-> FROM ss
-> WHERE release=CURDATE()
-> GROUP BY cell
-> HAVING sector=1 AND (cell=148 or cell=3);
+------+--------+------+------+------+-------+------+------+------+------+--
------+------+
| cell | sector | att | lc | csh | drops | tccf | bpp | bpc | suf |
blocks | mou |
+------+--------+------+------+------+-------+------+------+------+------+--
------+------+
| 3 | 1 | 734 | 12 | 6 | 2.52 | 21 | 0 | 0 | 0 |
2.86 | 1501 |
| 148 | 1 | 2746 | 93 | 30 | 4.59 | 63 | 0 | 0 | 1 |
2.33 | 4672 |
+------+--------+------+------+------+-------+------+------+------+------+--
------+------+
And have it display the two rows as a total sum together in one row?
I have been struggling with this and could really use some help.
Thanks in advance for any ideas.....
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
