Pretty lame. -----Original Message----- From: [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com] Sent: Thursday, October 31, 2002 11:58 AM To: Black, Kelly W [PCS] Subject: Re: SELECT
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi I could use some advice on a select statement. I have this select statement, which works great: SELECT 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 ),2) / ROUND(SUM(att),2) AS blocks, sum(mou) as mou, release FROM ss WHERE release=CURDATE() AND (( cell=2 and sector=1) OR (cell=3 and sector=1)) GROUP BY cell ORDER BY hour; However I want to be able to sum the two rows displayed together as well..... Right now it produces this => +------+------+------+-------+------+------+------+------+---------+------+- -----------+ | att | lc | csh | drops | tccf | bpp | bpc | suf | blocks | mou | release | ------+------+------+------+-------+------+------+------+------+---------+-- ----+------------+ | 75 | 4 | 2 | 9.23 | 10 | 0 | 0 | 0 | 13.3333 | 232 | 2002-10-31 | | 644 | 24 | 8 | 5.03 | 8 | 0 | 0 | 0 | 1.2422 | 1802 | 2002-10-31 | +------+------+------+------+-------+------+------+------+------+---------+- -----+------------+ I want it to produce something like this _> +------+------+------+-------+------+------+------+------+---------+------+- -----------+ | att | lc | csh | drops | tccf | bpp | bpc | suf | blocks | mou | release | +------+------+------+-------+------+------+------+------+---------+------+- -----------+ | 739 | 28 | 10 | 11.3 | 18 | 0 | 0 | 0 | 14.5333 | 2032 | 2002-10-31 | +------+------+------+-------+------+------+------+------+---------+------+- -----------+ And help or ideas would be most appreciated.... Regards, Kelly Black Irvine, Ca. 92612 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
